2016-12-07 16:57 GMT+01:00 Rich Shepard <rshep...@appl-ecosys.com>: > 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 (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
