> 1. Is it documented anywhere that an apostrophe / single quote is bad news
> inside of a C-style /* .... */ comment? I just found out the hard way.
> Seems to be OK inside of the one line -- comment.
Seems to work here:
test=> select *
test-> /* 'test'
test*> */
test-> from pg_language;
lanname | lanispl | lanpltrusted | lanplcallfoid | lancompiler
----------+---------+--------------+---------------+-------------
internal | f | f | 0 | n/a
C | f | f | 0 | /bin/cc
sql | f | f | 0 | postgres
(3 rows)
> 2. How does one view column comments created with COMMENT ON COLUMN?
psql \d+ command. Not sure if \dd works too.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026