Re: [GENERAL] listing all tables - Mailing list pgsql-general

From Fandarel
Subject Re: [GENERAL] listing all tables
Date
Msg-id 199807161851.OAA25429@hub.org
Whole thread Raw
Responses Re: [GENERAL] listing all tables  (Rostislav Matl <xmatl@informatics.muni.cz>)
List 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


pgsql-general by date:

Previous
From: Fandarel
Date:
Subject: Tables with oid
Next
From: "Ryan Mchale"
Date:
Subject: Autonumbering column