"Phillip J. Allen" <paallen(at)attglobal(dot)net> writes:
> I just got the PG 7.3.1 installed and am now experimenting with
> schemas. Now when I do a "\dt" in psql I only get a listing of tables
> in the current schema (public by default).
> So how do I get a listing in psql for:
> 1. all the schemas that exist in the database
As of 7.3, we didn't get around to providing a backslash command in psql
to do this, but "select * from pg_namespace" will answer.
> 2. all the tables in all schemas
Try "\dt *.*"
regards, tom lane