Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA82737 for ; Fri, 20 Aug 1999 23:34:41 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id XAA21422; Fri, 20 Aug 1999 23:34:01 -0400 (EDT) To: gordonc@cyberbiz.net.au cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Question about comments In-reply-to: Your message of Sat, 21 Aug 1999 10:58:16 +1000 (EST) Date: Fri, 20 Aug 1999 23:34:01 -0400 Message-ID: <21420.935206441@sss.pgh.pa.us> From: Tom Lane 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... regards, tom lane