Re: [General] Comments - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [General] Comments
Date
Msg-id 200101241543.KAA25815@candle.pha.pa.us
Whole thread Raw
In response to [General] Comments  ("Brian E. Pangburn" <bepangburn@yahoo.com>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: "Lloyd Llewellyn"
Date:
Subject: GUI admin interface - where??
Next
From: Bruce Momjian
Date:
Subject: Re: pg_logs and pg_variables Files