pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Justin Clift <jc@telstra.net>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Adding column comment to information_schema.columns
Date: Fri, 02 Jul 2004 12:50:45 +1000
Message-ID: <40E4CD85.1040000@telstra.net> (raw)
In-Reply-To: <270f2a128cf161491a34c16ee00b082e@biglumber.com>
References: <270f2a128cf161491a34c16ee00b082e@biglumber.com>

Greg Sabino Mullane wrote:
<snip>
> If there is that much clamor for this, why not make a new schema,
> such as "pginformation_schema" People could then tweak the views
> to their heart's content, while keeping 100% compliance.

Doesn't sound very neat.

If we add a pginformation_schema, then it'd probably contain all of the 
existing information_schema... plus more.  Reduplication?

I guess we could just leverage off the existing information_schema views:

i.e.

CREATE VIEW pg_information_schmema.some_view AS SELECT * FROM 
information_schema.some_view (then add extra bits).

But it still doesn't sound very neat.

?

Regards and best wishes,

Justin Clift




view thread (38+ messages)  latest in thread

Message-ID: <40E4CD85.1040000@telstra.net>
Permalink:  ../40E4CD85.1040000@telstra.net/
Also on:    postgresql.org/message-id/40E4CD85.1040000@telstra.net

 · 

reply

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: jc@telstra.net, greg@turnstep.com
  Subject: Re: Adding column comment to information_schema.columns
  In-Reply-To: <40E4CD85.1040000@telstra.net>

* 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