X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4E190D1B18C for ; Sun, 4 Jul 2004 23:54:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29894-05 for ; Mon, 5 Jul 2004 02:54:17 +0000 (GMT) Received: from mako1.telstra.net (mako1.telstra.net [203.50.0.28]) by svr1.postgresql.org (Postfix) with ESMTP id F1A7AD1B1A9 for ; Sun, 4 Jul 2004 23:54:12 -0300 (ADT) Received: from telstra.net (xena.telstra.net [203.50.0.233]) by mako1.telstra.net (8.12.9/8.11.1) with ESMTP id i652s6B4098867; Mon, 5 Jul 2004 12:54:11 +1000 (EST) (envelope-from jc@telstra.net) Message-ID: <40E8C27E.2050505@telstra.net> Date: Mon, 05 Jul 2004 12:52:46 +1000 From: Justin Clift User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.1) Gecko/20040406 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christopher Kings-Lynne Cc: PostgreSQL Hackers Mailing List Subject: Re: Adding column comment to information_schema.columns References: <40E37E3F.2050400@telstra.net> <22066.1088656403@sss.pgh.pa.us> <40E3949F.6020201@telstra.net> <40E3BB25.4020804@pse-consulting.de> <40E4C305.4070309@familyhealth.com.au> <40E4C367.2080303@telstra.net> <1088769438.15415.1.camel@fuji.krosing.net> <40E5716D.70403@familyhealth.com.au> In-Reply-To: <40E5716D.70403@familyhealth.com.au> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/209 X-Sequence-Number: 55770 Christopher Kings-Lynne wrote: >>> Well, if we add them (and they would be very useful I reckon) should >>> we ensure there's an obvious PG naming thing happening? > > Why are they useful???? If you want PG specific stuff then use the PG > specific catalogs!!! My take on this is that it's a LOT easier for people who don't know the internals of the PG catalogs to be able to query the information schema, as in the information schema things are generally explicitly named. Much easier for non-experts, which most people don't want to have to invest the time in becoming. Regards and best wishes, Justin Clift > Chris