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

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

In response to

Responses

Browse pgsql-hackers by date

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