pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
Subject: Re: Insert a description while creating a table
Date: Wed, 13 Aug 2003 15:23:48 +0200
Message-ID: <3F3A3BE3.2A2B7D0@rodos.fzk.de> (raw)

> 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







view thread (8+ messages)

Message-ID: <3F3A3BE3.2A2B7D0@rodos.fzk.de>
Permalink:  ../3F3A3BE3.2A2B7D0@rodos.fzk.de/
Also on:    postgresql.org/message-id/3F3A3BE3.2A2B7D0@rodos.fzk.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ch@rodos.fzk.de
  Subject: Re: Insert a description while creating a table
  In-Reply-To: <3F3A3BE3.2A2B7D0@rodos.fzk.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox