Re: Views, views, views! (long)

On Fri, May 06, 2005 at 11:34:49AM -0000, Greg Sabino Mullane wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> > And what about users who's interface to PostgreSQL is psql?
>
> Backslash commands.

There's a ton of cases the backslash commands don't cover, which others
have given examples of. Even if we went to town and added a whole bunch
of extra backslash commands, there's still going to be things that just
aren't covered.

Aside from that, it's currently rather silly that every admin tool has
to code up a very complex set of queries to get info from the system
catalog. It makes much more sense to put that complexity into a set of
system views that are maintained as part of the backend, instead of
pushing that effort out to everyone who writes tools.
--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"