2016-12-07 16:57 GMT+01:00 Rich Shepard <[email protected]>: > I have used '-- ' to enter comments about tables or columns and am > curious > about the value of storing comments in tables using the COMMENT key word. > When is the latter more appropriate than the former? >
Description entered with COMMENT statements is persistently saved in database system catalogue - see table pg_description. You can get the comment for any database object. Comments like '--' or '/* ... */ are comments in source code, and they are just ignored in processing. Regards Pavel > > TIA, > > Rich > > > -- > Sent via pgsql-general mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
