Re: Views, views, views! (long)

Greg Sabino Mullane <greg@turnstep.com>

From: "Greg Sabino Mullane" <greg@turnstep.com>
To: pgsql-hackers@postgresql.org
Date: 2005-05-05T22:43:07Z
Lists: pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> The purpose of the new system views...

As long as they are in a separate schema (like information_schema,
but hopefully not as long). pg_views? pg_info? information_skema? :)

> But if you think that nobody needs these views, it's because you
> haven't had much contact with end users lately.

Well, who really *does* need these? After all, end users should be
using an interface of some sort. (DBD::Pg, phpPgAdmin, psql, etc). It's
the job of the people writing those interfaces to know the system
catalogs well and present them to the users in a pretty fashion. If
people want an "easy" way to look up the information, they use an
interface. If not, they should learn the system catalogs.
/devilsadvocate

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200505050632
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCefgSvJuQZxSWSsgRAlhmAKCXhqS9b5n5PgmWutFAzR6D5rg5SQCfQpuL
qpOQ/PBghtBbI8RkJ2tXM7s=
=0d0+
-----END PGP SIGNATURE-----