pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Question 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