Re: \d type queries - why not views in system catalog?!? - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: \d type queries - why not views in system catalog?!?
Date
Msg-id 1042476281.66924.9.camel@jester
Whole thread Raw
In response to Re: \d type queries - why not views in system catalog?!?  (greg@turnstep.com)
List pgsql-hackers
On Mon, 2003-01-13 at 11:28, greg@turnstep.com wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> NotDashEscaped: You need GnuPG to verify this message
>
>
> > Wouldn't it be easier (and more portable, see 7.3/7.2 system catalogs vs.
> > psql) to have views for that? Do I miss a point here?
>
> Putting the \d commands into views has been on the TODO list for a long time:
> I think it is actually the only psql-related item left, until we change
> the backend protocol to indicate transaction state. I don't think a view
> would have helped with the psql 7.2/7.3 change: a lot more changed than
> simply the underlying SQL.

It would be a wise idea to use the INFORMATION_SCHEMA where possible for
these, as that is pretty much guaranteed to be static in format.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

pgsql-hackers by date:

Previous
From: greg@turnstep.com
Date:
Subject: Re: \d type queries - why not views in system catalog?!?
Next
From: greg@turnstep.com
Date:
Subject: Re: PostgreSQL site, put up or shut up?