Subject: Re: Adding column comment to information_schema.columns
From: Robert Treat <xzilla@users.sourceforge.net>
To: Hannu Krosing <hannu@tm.ee>
Cc: Justin Clift <jc@telstra.net>,
	PostgreSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
In-Reply-To: <1088769438.15415.1.camel@fuji.krosing.net>
References: <40E37E3F.2050400@telstra.net> <22066.1088656403@sss.pgh.pa.us>
	<40E3949F.6020201@telstra.net> <40E3BB25.4020804@pse-consulting.de>
	<k6xn3cph.fsf@bullysports.com> <40E4C305.4070309@familyhealth.com.au>
	<40E4C367.2080303@telstra.net>
	<1088769438.15415.1.camel@fuji.krosing.net>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: 02 Jul 2004 10:12:07 -0400
Message-Id: <1088777527.31171.342.camel@camel>
Mime-Version: 1.0

On Fri, 2004-07-02 at 07:57, Hannu Krosing wrote:
> On R, 2004-07-02 at 05:07, Justin Clift wrote:
> > Christopher Kings-Lynne wrote:
> > >> There is a huge difference between adhering to a standard and limiting
> > >> yourself to a standard.  The real question is whether PostgreSQL's
> > >> goal is to support SQL standards, or whether PostgreSQL's goal is to
> > >> give PostgreSQL users a useful set of tools.
> > > 
> > > 
> > > There are literally _hundreds_ of fields we could add to the 
> > > information_schema.  Either we add them all or we add none of them.
> > 
> > Well, if we add them (and they would be very useful I reckon) should we 
> > ensure there's an obvious PG naming thing happening?
> > 
> > i.e.  pg_column_comment
> > 
> > or similar?  Maybe not "pg_" but you know what I mean.
> 
> IIRC we were recently told (in this thread) that the SQL standard tells
> to end local customisations with underscore, so it would be
> 'column_comment_'
> 

Yup... but before we go to far I think anyone who is thinking of adding
a column should see if there is a comparable column in
oracle/db2/$ql$erver.  The point of information_schema (at least one
point of it) is to help application writers to write code that works
across different database systems and I wouldn't be surprised if those
folks had already extended the information_schema in some way.

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL