Re: Views, views, views! (long) - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: Views, views, views! (long)
Date
Msg-id 20050506160702.GM88920@decibel.org
Whole thread Raw
In response to Re: Views, views, views! (long)  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: Views, views, views! (long)
List pgsql-hackers
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@decibel.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?"


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database properties not being duplicated
Next
From: Andrew Dunstan
Date:
Subject: Re: pl/pgsql enabled by default