Re: psql and schemas - Mailing list pgsql-hackers

From Neil Conway
Subject Re: psql and schemas
Date
Msg-id 1099456069.9284.95.camel@localhost.localdomain
Whole thread Raw
In response to Re: psql and schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, 2004-11-02 at 01:44, Tom Lane wrote:
> Neil Conway <neilc@samurai.com> writes:
> > I think there needs to be a way to list all the objects in a schema.
> 
> This doesn't seem especially helpful to me, because you'd have to fit a
> bunch of different object types into a one-size-fits-all output, which
> would end up fitting nothing very well.

The same comment applies to "\d", but I think that is still a useful
command. Note that we wouldn't need to list _everything_ in a schema for
this to be useful, in the same way that "\d" doesn't list everything in
the search path.

> It's not clear to me that we need do more, especially since the user
> probably knows what kinds of objects he's created

Among other things, psql is a tool for exploring the content of a
database; assuming that the user already knows what is in the database
doesn't strike me as wise. I can think of plenty of scenarios in which
someone using psql would like to get a quick summary of the content of a
schema they know nothing about.

But in any case I'll leave this for later.

-Neil




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [pgsql-hackers-win32] Edit query buffer
Next
From: Tatsuo Ishii
Date:
Subject: Re: charset/collation in values