Re: Insert a description while creating a table - Mailing list pgsql-sql

From Christoph Haller
Subject Re: Insert a description while creating a table
Date
Msg-id 3F3A3BE3.2A2B7D0@rodos.fzk.de
Whole thread Raw
In response to Insert a description while creating a table  (luiz@klais.com.br)
List pgsql-sql
> 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






pgsql-sql by date:

Previous
From: Reinoud van Leeuwen
Date:
Subject: Re: Insert a description while creating a table
Next
From: Christoph Haller
Date:
Subject: Re: Order of triggers - totally lost