Re: How to retrieve a comment/description from a table

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Marcus Claesson <marcus(dot)claesson(at)angiogenetics(dot)se>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to retrieve a comment/description from a table
Date: 2002-08-23 15:37:16
Message-ID: 20020823083454.F20653-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2002-08-23 16:40:43 Re: integer[] Update Questions
Previous Message Bruce Momjian 2002-08-23 15:29:33 Re: Mysql -> PgSQL