Re: Adding column comment to information_schema.columns - Mailing list pgsql-hackers

From Justin Clift
Subject Re: Adding column comment to information_schema.columns
Date
Msg-id 40E4CD85.1040000@telstra.net
Whole thread Raw
In response to Re: Adding column comment to information_schema.columns  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Re: Bug with view definitions?
Next
From: Christopher Kings-Lynne
Date:
Subject: compile errors in new PL/Pler