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?
TIA,
Rich
-- is a comment which is like a language comment: it has _no_ effect on the program being compiled. Likewise --
is simply ignored. The value in a COMMENT is actually stored in the data base. For example:
tsh009=# comment on schema racf is 'Snapshot of z/OS RACF database via IRRDBU00 output';COMMENT
tsh009=# \dn+
List of schemas
Name | Owner | Access privileges | Description
--------+----------+----------------------+----------------------------------------------------
dasd | tsh009 | |
junk | tsh009 | |
public | postgres | postgres=UC/postgres+| standard public schema
| | =UC/postgres |
racf | tsh009 | | Snapshot of z/OS RACF database via IRRDBU00 output
tape | tsh009 | |
tmc | tsh009 | |
(6 rows)
Maranatha! <><
John McKown
John McKown
