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

From greg@turnstep.com
Subject Re: \d type queries - why not views in system catalog?!?
Date
Msg-id dde26ecf46ba710a503635bf28914c4c@biglumber.com
Whole thread Raw
In response to \d type queries - why not views in system catalog?!?  (Joerg Hessdoerfer <Joerg.Hessdoerfer@sea-gmbh.com>)
Responses Re: \d type queries - why not views in system catalog?!?  (Rod Taylor <rbt@rbt.ca>)
Re: \d type queries - why not views in system catalog?!?  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
-----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.

Some of the the backslash commands are not amenable to putting inside a 
view, as they actually compromise multiple SQL calls and some logic in 
the C code, but a few could probably be made into views. Could whomever 
added that particular TODO item expand on this?

--
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200301131137

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+IuuovJuQZxSWSsgRAgQXAKCdu0+CelZ1V2bwI/HoJHIz+a3DPACgix7u
pOcRXwHb+4NJLMeSpNaqzRM=
=0yFo
-----END PGP SIGNATURE-----




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: \d type queries - why not views in system catalog?!?
Next
From: Rod Taylor
Date:
Subject: Re: \d type queries - why not views in system catalog?!?