Re: \d type queries - why not views in system catalog?!?

On Mon, 2003-01-13 at 11:28, greg(at)turnstep(dot)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(at)rbt(dot)ca>

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