Re: SQL to get a table columns comments?

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SQL to get a table columns comments?
Date: 2007-01-30 06:32:11
Message-ID: 20070130063211.GB12767@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

am Sat, dem 27.01.2007, um 17:57:06 -0800 mailte Timasmith folgendes:
> Hi,
>
> What query can I run to get the comments for my table columns.
>
> i.e. the ones on my 8.1 database added with this command:
>
> COMMENT ON COLUMN addresses.address_id IS 'Unique identifier for the
> addresses table';

Start psql with Option -E and type '\d+ <tablename>'. (without the ')

Then you can see the underlaying SQL-Query to request this.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hakan Kocaman 2007-01-30 06:32:57 Re: PG Email Client
Previous Message Panther 2007-01-30 06:07:16 SELECT FOR UPDATE with ORDER BY to avoid row-level deadlock?

Browse pgsql-hackers by date

  From Date Subject
Next Message Ken Johanson 2007-01-30 06:53:51 V3 protocol; way to return table aliases?
Previous Message Tom Lane 2007-01-30 04:28:52 Re: Proposal: Snapshot cloning