From: | greg(at)turnstep(dot)com |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: \d type queries - why not views in system catalog?!? |
Date: | 2003-01-13 16:28:06 |
Message-ID: | dde26ecf46ba710a503635bf28914c4c@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)turnstep(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | greg | 2003-01-13 16:40:32 | Re: PostgreSQL site, put up or shut up? |
Previous Message | Tom Lane | 2003-01-13 16:19:46 | Re: \d type queries - why not views in system catalog?!? |