Re: How to retrieve a comment/description from a table - Mailing list pgsql-general

From Stephan Szabo
Subject Re: How to retrieve a comment/description from a table
Date
Msg-id 20020823083454.F20653-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: How to retrieve a comment/description from a table  (Marcus Claesson <marcus.claesson@angiogenetics.se>)
List pgsql-general
On Fri, 23 Aug 2002, Marcus Claesson wrote:

> > \d+ mytable will give you the comments for it
>
> This only gives me the same information as if I wrote '\d mytable', plus an
> empty description column.  I couldn't see my comment anywhere.
>
> What I wish is to retrieve the comment with a sql question, which would work
> if the '\d+ information' could be found in an actual table somewhere.

If you start psql with -E it will show you the queries it's running for
those backslash commands.

I believe \d+ table gives you column descriptions in that description
column.


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Mysql -> PgSQL
Next
From: Oleg Bartunov
Date:
Subject: Re: integer[] Update Questions