Whilst reading http://www.postgresql.org/docs/8.2/interactive/sql-comment.html
I came across this user comment:
Ricardo Bánffy 04 Sep 2007 18:15:44
It is a pretty obvious suggestion I bet was made many, many times
before, but it would be very useful if you could create comments while
creating the objects themselves, like
CREATE TABLE FOO (
ID INTEGER NOT NULL PRIMARY KEY COMMENT 'The ID',
VALUE VARCHAR(10) COMMENT 'The value',
) COMMENT 'The table';
This would be a good thing as it would make documenting schemas more
in-your-face and less prone to forgetting (ie, atm, if you do want to
comment on rows you effectively wind up with two table definitions
(kinda)).
Perhaps this is a small enough add to make it into 8.3?
--
"To the extent that we overreact, we proffer the terrorists the
greatest tribute."
- High Court Judge Michael Kirby
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
