Horton

Re: [GENERAL] listing all tables

Rostislav Matl <xmatl@informatics.muni.cz>

View thread View on postgr.es
From: Rostislav Matl <xmatl@informatics.muni.cz>
To: pgsql-general@postgreSQL.org
Date: 1998-07-17T19:28:23Z
Lists: pgsql-general 
On 16-Jul-98 Fandarel wrote:
>>   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
> 

It's in docs even maybe in FAQs, or in archive - it was already discussed.

+-----------------------------------------------------------------------------+
|  ROSTISLAV MATL, student of Masaryk University - Faculty of Informatics     |
|  e-mail: xmatl@fi.muni.cz      WWW: http://www.fi.muni.cz/~xmatl/index.html | 
+-----------------------------------------------------------------------------+