On Thu, 2002-07-04 at 22:07, Christopher Kings-Lynne wrote:
> > > We could change pg_attribute to another name, and create a view called
> > > pg_attribute that never returned isdropped columns to the client. That
> > > would allow clients to work cleanly, and the server to work cleanly.
> >
> > Another case where having an informational schema would eliminate the
> > whole argument -- as the clients wouldn't need to touch the system
> > tables.
>
> Since postgres has so many features that standard SQL doesn't have (eg.
> custom operators), how are they going to be shown in the information schema?
I would assume we would add pg_TABLE or TABLES.pg_COLUMN as appropriate
and where it wouldn't disturbe normal usage.
If we always put pg columns at the end it shouldn't disturbe programs
which use vectors to pull information out of the DB with a target of *.