On Tue, 2004-11-02 at 01:44, Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
