Search Postgresql Archives

Re: Table Comments

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 15 Sep 2010 08:53:16 -0700, Carlos Mennens <carlos.mennens@xxxxxxxxx> 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.

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux