Re: [GENERAL] listing all tables

Matt Vanderpol <fandarel@mail.solisys.com>

From: Fandarel <fandarel@mail.solisys.com>
To: "Ryan Mchale" <sdecoop2@nortel.ca>, <pgsql-general@postgreSQL.org>
Date: 1998-07-16T18:50:39Z
Lists: pgsql-general
>   How would I list all tables in a database?

You can list all tables with:

select * from pg_class;

but that will give you system tables also.

I think that if you use the \z command in psql, it will give you a list 
of all tables in the current database.

Matt