Re: Dealing with schema in psql utility? - Mailing list pgsql-general

Tariq Muhammad <tmuhamma@libertyrms.com> writes:
> On Thu, 20 Feb 2003, Dan Delaney wrote:
>> 1) get a list of the schema that have been created in the current
>> database

> select * from pg_namespace ;

7.4 psql will also offer "\dn".  We didn't get around to making this
happen for 7.3.

>> 2) View the list of tables in a schema other than "public"?

Try "\dt myschema.*"

>> 3) Rename a schema (is there an "alter schema" statement)?

On the to-do list, but not done yet.  As Tariq says, an ALTER command
will serve for the moment.

            regards, tom lane