Message-ID: <3F3A3BE3.2A2B7D0@rodos.fzk.de>
Date: Wed, 13 Aug 2003 15:23:48 +0200
From: Christoph Haller <ch@rodos.fzk.de>
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Insert a description while creating a table
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit

> On Wed, Aug 13, 2003 at 02:54:59PM +0200, Christoph Haller wrote:
> > \dd test shows
> >
> >          Object descriptions
> >  Schema | Name | Object | Description
> > --------+------+--------+-------------
> > (0 rows)
> >
> > This is odd. OK, I know the doc says
> > \dd [ pattern ]
> >
> >     Shows the descriptions of objects matching the pattern, or of
all
> > visible objects if no argument is given. But in either case,
> >     only objects that have a description are listed. ("Object"
covers
> > aggregates, functions, operators, types, relations (tables, views,
> >     indexes, sequences, large objects), rules, and triggers.) For
> > example:
> >
> > Nothing about columns.
> > But what is the purpose of comments on columns if you can only get
them
> > via
> > select * from pg_description where
>
> Have you tried \d+ tablename? (sorry for the long lines ";-)
>
I apologize for complaining, missed that completely.
Thanks to Reinoud for pointing this out.

Regards, Christoph