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

-----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-----