Re: When to use COMMENT vs --

On Wed, Dec 7, 2016 at 9:57 AM, Rich Shepard <rshepard(at)appl-ecosys(dot)com>
wrote:

> 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)

​
​

--
Heisenberg may have been here.

Unicode: http://xkcd.com/1726/

Maranatha! <><
John McKown