Re: psql and schemas - Mailing list pgsql-hackers

From Tom Lane
Subject Re: psql and schemas
Date
Msg-id 13269.1099320282@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql and schemas  (Neil Conway <neilc@samurai.com>)
Responses Re: psql and schemas  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> I'm not sure how we should handle "\dn schema_name." (notice the period;
> assuming a schema with that name exists). The current behavior of
> listing all schemas is obviously wrong, but I'm not sure what the right
> behavior is. Perhaps we should reject the command?

Seems reasonable to me.  There shouldn't ever be a dot in the argument
of \dn.

> 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.  You can get the effect with\d schema_name.*\df schema_name.*\do
schema_name.*\daschema_name.*etc
 
It's not clear to me that we need do more, especially since the user
probably knows what kinds of objects he's created, and can skip
unnecessary steps.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: GiST memory allocation
Next
From: Gaetano Mendola
Date:
Subject: Design by contract