Re: Table Comments

On 09/15/2010 08:53 AM, Carlos Mennens wrote:
> I saw in the documentation for PostgreSQL that I can add 'comments' to
> table entries when creating columns:
>
> http://www.postgresql.org/docs/8.1/static/tutorial-table.html
>
> CREATE TABLE weather (
>      city            varchar(80),
>      temp_lo         int,           -- low temperature
>      temp_hi         int,           -- high temperature
>      prcp            real,          -- precipitation
>      date            date
> );
>
> 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;
>
> Any suggestions?
>
>
Don't confuse "--" with "COMMENT ON".

A -- is SQL's comment "character",  like # in Bash, // in C, etc. so you
can comment the SQL statements in your code.

The "COMMENT ON" statement lets you add descriptions to database objects
(tables, individual columns, etc.). See
http://www.postgresql.org/docs/8.1/static/sql-comment.html for more on
the COMMENT statement.

Cheers,
Steve