Jul 23, 2007 #1 mjesus Technical User Jul 23, 2007 1 BR Is that possible CREATE TABLE already with table and/or column comment? If so how?
Jul 24, 2007 1 #2 ConradIrwin Programmer Jul 5, 2007 4 GB 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. Upvote 0 Downvote
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.
Jul 24, 2007 1 #3 ceco IS-IT--Management Oct 16, 2002 229 BG 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'; Upvote 0 Downvote
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';