Re: psql and schemas

On Tue, 2004-11-02 at 01:44, Tom Lane wrote:
> Neil Conway <neilc(at)samurai(dot)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