Re: [GENERAL] getting comment about constraint

2006-06-22 Thread Michael Fuhr
On Sun, Jun 18, 2006 at 03:02:05PM -0700, [EMAIL PROTECTED] wrote: > Given the name of the table and constraint, how would you retrieve the > comment? "Chapter 9. Functions and Operators" says that > obj_description(object_oid, catalog_name) returns a comment given the > object's OID and class nam

[GENERAL] getting comment about constraint

2006-06-21 Thread canfieldsteve
How do you retrieve a comment on a constraint? For example, consider the following table and comment: create table people ( person_id serialprimary key, uid varchar(25) not null, constraint uid_alphanumeric check (uid ~ '^[a-z0-9_]+$') ); comment on constra