Where do COMMENTs on columns go?

Поиск
Список
Период
Сортировка
От Nancy Ellman
Тема Where do COMMENTs on columns go?
Дата
Msg-id Pine.LNX.4.21.0012041358220.24374-100000@pine.cs.yale.edu
обсуждение исходный текст
Ответы Re: Where do COMMENTs on columns go?  ("Roderick A. Anderson" <raanders@tincan.org>)
Список pgsql-general

According to the documentation for COMMENT, it puts a comment on
object "that can be easily retrieved with psql's \dd command."

Examples like

    COMMENT on table mytable is 'foo';
    COMMENT on column mytable.mycolumn is 'bar';

are given.

However, while I have been able to see the results of the first
example with

    \dd mytable

I have not been able to get \dd to show the comments on the
individual columns.

Can someone tell me how to do that?

I am running postgresql-7.0.2.

Thanks,

Nan Ellman

PS Please email any replies to me directly.




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

Предыдущее
От: Christian Ullrich
Дата:
Сообщение: Re: Failed regression tests with 7.0.3 on Windows NT 4.0
Следующее
От: "Joel Burton"
Дата:
Сообщение: Re: [SQL] Access Permissions/Security