Re: How to list schemas and table in psql? - Mailing list pgsql-novice

"Phillip J. Allen" <paallen@attglobal.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