Re: [SQL] COMMENT ON CONSTRAINT

2004-08-15 Thread Andreas Seltenreich
Sascha Ziemann writes: > it is defined in this way: [...] > CONSTRAINT constraint_name ON table_name | Well then... > comment on constraint uni on table tab3 is 'unique pair'; ^ ...why do you insert "table" when it is defined without? :-) regards Andreas --

[SQL] COMMENT ON CONSTRAINT

2004-08-15 Thread Sascha Ziemann
Hi, I have a problem with the COMMENT command. Here: http://www.postgresql.org/docs/7.4/static/sql-comment.html it is defined in this way: COMMENT ON { TABLE object_name | COLUMN table_name.column_name | AGGREGATE agg_name (agg_type) | CONSTRAINT constraint_name ON table_name | DATAB