From: | "Brian E(dot) Pangburn" <bepangburn(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [General] Comments |
Date: | 2001-01-24 20:00:03 |
Message-ID: | 94nc84$2jtr$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2001-01-24 20:12:36 | Re: [GENERAL] jdbc driver, error trapping. |
Previous Message | Anand Raman | 2001-01-24 19:45:39 | Re: backend closing connections while executing... |