pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion about comments
3+ messages / 3 participants
[nested] [flat]
* Question about comments
@ 1999-08-21 00:58 Gordon Clarke <gordonc@cyberbiz.net.au>
1999-08-21 03:34 ` Re: [SQL] Question about comments Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Gordon Clarke @ 1999-08-21 00:58 UTC (permalink / raw)
To: pgsql-sql
I posted this msg previously but received no responses, perhaps this
time??
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?
Thanks.
Cheers...Gordon
~~~~~~~~~~~~~~ 4ZzZ Brisbane's First Community FM Station ~~~~~~~~~~~~~~
The Demo Show - Supporting Australian Unsigned Artists
Mon nights 6-7pm (0800-0900UTC) on 4ZzZ 102.1 FM
http://www.4zzzfm.org.au/welcome.html (RA feed)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] Question about comments
1999-08-21 00:58 Question about comments Gordon Clarke <gordonc@cyberbiz.net.au>
@ 1999-08-21 03:34 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-08-24 04:07 ` Re: [SQL] Question about comments Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 1999-08-21 03:34 UTC (permalink / raw)
To: gordonc@cyberbiz.net.au; +Cc: pgsql-sql
Gordon Clarke <gordonc@cyberbiz.net.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] Question about comments
1999-08-21 00:58 Question about comments Gordon Clarke <gordonc@cyberbiz.net.au>
1999-08-21 03:34 ` Re: [SQL] Question about comments Tom Lane <tgl@sss.pgh.pa.us>
@ 1999-08-24 04:07 ` Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 1999-08-24 04:07 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: gordonc@cyberbiz.net.au; pgsql-sql
> Gordon Clarke <gordonc@cyberbiz.net.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...
Yes, that is on the TODO list. Currently, the initdb command pulls
hard-coded comments out of the include/catalog/*.h files, and loads them
in indexed on oid. You can add your own.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-08-24 04:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-21 00:58 Question about comments Gordon Clarke <gordonc@cyberbiz.net.au>
1999-08-21 03:34 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-08-24 04:07 ` Bruce Momjian <maillist@candle.pha.pa.us>
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