Erwin Brandstetter wrote:
- Trying to add a comment to UNIQUE CONSTRAINT fails altogether.
Actually, it doesn't fail to write. It just doesn't show up anywhere in
pgadmin afterwards.
psql doesn't seem to have a meta-command to retrieve comments on
constraints. But checking by OID with "obj_description" reveals it:
SELECT obj_description(2666870, 'pg_constraint');
Regards
Erwin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
