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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
