Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id AAA81640 for ; Tue, 24 Aug 1999 00:30:43 -0400 (EDT) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id AAA16014; Tue, 24 Aug 1999 00:07:52 -0400 (EDT) From: Bruce Momjian Message-Id: <199908240407.AAA16014@candle.pha.pa.us> Subject: Re: [SQL] Question about comments In-Reply-To: <21420.935206441@sss.pgh.pa.us> from Tom Lane at "Aug 20, 1999 11:34:01 pm" To: Tom Lane Date: Tue, 24 Aug 1999 00:07:52 -0400 (EDT) CC: gordonc@cyberbiz.net.au, pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL56 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > Gordon Clarke 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