getting comment about constraint

Поиск
Список
Период
Сортировка
От canfieldsteve@hotmail.com
Тема getting comment about constraint
Дата
Msg-id 1150668125.327100.277760@u72g2000cwu.googlegroups.com
обсуждение исходный текст
Ответы Re: getting comment about constraint  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
How do you retrieve a comment on a constraint?  For example, consider
the following table and comment:

 create table people (
    person_id     serial        primary key,
    uid           varchar(25)   not null,
    constraint uid_alphanumeric check (uid ~ '^[a-z0-9_]+$')
 );

 comment on constraint uid_alphanumeric on people
   is 'UID may only contain letters, numerals, and underscores';

That code code creates a constraint within the "people" table named
"uid_alphanumeric".  Furthermore, it creates a comment on that
constraint.

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 name.  How do I get the OID for the constraint?
It doesn't seem to be stored in pg_constraint.


В списке pgsql-general по дате отправления:

Предыдущее
От: "Erin Sheldon"
Дата:
Сообщение: Changing array subscripting to zero-offset
Следующее
От: "Vladimir Leban"
Дата:
Сообщение: Unable to start pg service