Re: [General] Comments

With the help of Bruce Momjian and Tom Lane I was able to resolve my two
issues:

In PG 7.0.x, the following won't work because of the single apostrophe:
> test=> select *
> test-> /* doesn't work...
> test'> */
> test'> from pg_language;

It is reportedly fixed for 7.1

The following will display any column comments for "mytable"
\d+ mytable

Brian E. Pangburn

"Brian E. Pangburn" <bepangburn(at)yahoo(dot)com> wrote in message
news:94i0d5$15s6$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> 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.
> 2. How does one view column comments created with COMMENT ON COLUMN?
>
> TIA.
> Brian E. Pangburn