Re: Getting comments from schema using SQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Getting comments from schema using SQL
Дата
Msg-id 22622.1170121163@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Getting comments from schema using SQL  (google@jessehersch.fastmail.fm)
Список pgsql-hackers
google@jessehersch.fastmail.fm writes:
> On Jan 29, 2:40 pm, "Timasmith" <timasm...@hotmail.com> wrote:
>> What query can I run to get the comments on my table columns using
>> SQL?

> check out the pg_description system catalog:
> http://www.postgresql.org/docs/8.2/static/catalog-pg-description.html

Also see obj_description() and friends, which are basically wrappers
for queries on that catalog:
http://www.postgresql.org/docs/8.2/static/functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE
        regards, tom lane


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

Предыдущее
От: "Jim Buttafuoco"
Дата:
Сообщение: Re: How to configure Postgres to make it not to use (load) crypto libraries.
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Modifying and solidifying contrib