Skip site navigation (1) Skip section navigation (2)

Re: Adding column comment to information_schema.columns

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Justin Clift <jc(at)telstra(dot)net>,PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adding column comment to information_schema.columns
Date: 2004-07-02 14:12:07
Message-ID: 1088777527.31171.342.camel@camel (view raw or flat)
Thread:
Lists: pgsql-hackers
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


In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2004-07-02 14:26:21
Subject: Re: compile errors in new PL/Pler
Previous:From: Larry RosenmanDate: 2004-07-02 13:26:18
Subject: Re: compile errors in new PL/Pler

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group