From: Robert Treat <xzilla@users.sourceforge.net>
To: Hannu Krosing <hannu@tm.ee>
Cc: Justin Clift <jc@telstra.net>
Cc: PostgreSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
Subject: Re: Adding column comment to information_schema.columns
Date: 02 Jul 2004 10:12:07 -0400
Message-ID: <1088777527.31171.342.camel@camel> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: xzilla@users.sourceforge.net, hannu@tm.ee, jc@telstra.net
Subject: Re: Adding column comment to information_schema.columns
In-Reply-To: <1088777527.31171.342.camel@camel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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