Re: [SQL] Question about comments

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gordonc(at)cyberbiz(dot)net(dot)au
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Question about comments
Date: 1999-08-21 03:34:01
Message-ID: 21420.935206441@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Gordon Clarke <gordonc(at)cyberbiz(dot)net(dot)au> writes:
> I'm running Postgresql 6.3.2.

> When ones gets help on the built-in commands that start with '\' there is
> a command '\dd [object]'. In the comments is says that it lists the
> comment for the object, eg. table, field etc.

> Is this command operative under 6.3.2? If so, how does one get the
> comment(s) into those objects? The '\h create table' etc gives no idea.
> Also which of the system tables (pg_?) are these comments written to?

pg_description, I believe. AFAIK there's no special support for adding
entries to it :-(. You can insert entries manually, but it'd be nicer
to have some kind of specialized command for that...

regards, tom lane

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Clayton Cottingham 1999-08-21 05:10:19 Re: [SQL] is this possible, maybe a todo ? function related
Previous Message Nicolas Cadou 1999-08-21 01:10:53 Re: [SQL] Missing PL/pgSQL library