Create table with comment 2

[mjesus]

Is that possible CREATE TABLE already with table and/or column comment?
If so how?

 

[ConradIrwin]

As far as I know this is not possible, there is no field in the table "pg_catalog"."pg_tables" that would seem to allow having a comment.

 

[ceco]

you can comment objects

http://www.postgresql.org/docs/8.2/interactive/sql-comment.html

but not with the create statement

CREATE TABLE "test"
(
"test" CHAR(36) NOT NULL,
PRIMARY KEY ("test")
);

COMMENT ON TABLE "test" IS 'this is realy test table';
COMMENT ON COLUMN "test"."test" IS 'this is the test column of the test table';