Re: Table Comments

Поиск
Список
Период
Сортировка
От Octavio Alvarez
Тема Re: Table Comments
Дата
Msg-id op.vi2z03d34oyyg1@alvarezp-ws
обсуждение исходный текст
Ответ на Table Comments  (Carlos Mennens <carlos.mennens@gmail.com>)
Список pgsql-general
On Wed, 15 Sep 2010 08:53:16 -0700, Carlos Mennens
<carlos.mennens@gmail.com> wrote:

> CREATE TABLE weather (
>     temp_lo         int,           -- low temperature
> );
>
> I did a search and don't understand in what aspect are the 'comments'
> relevant / visible? I don't see the comments when I attempt to list /
> describe the table with \d weather;

Those are comments to the SQL code, not comments to the columns. Comments
to SQL code are fully ignored by PostgreSQL on execution.

Those are useful if you have an SQL script and you want to document
something there.

For column comments you might want to take a look at the COMMENT command.

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Table Comments
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Table Comments