Thread: all tables in a DB\?

What SQL command can I issue in Postgresql to list all the tables in a
database?

Hi
Try the following SQL-Command:

SELECT relname
FROM pg_class
WHERE relname NOT LIKE 'pg_%';

In the table 'pg_class' you will find all tables created in the database.
Also the system-tables called pg_... (like pg_class).
greetings
rolf


"D'laila Pereira" <dlailap@home.com> schrieb im Newsbeitrag
news:Xh2c8.20270$tg4.228609@vixen.cso.uiuc.edu...
> What SQL command can I issue in Postgresql to list all the tables in a
> database?
>
>
>
>

\dt

Jie  Liang

-----Original Message-----
From: D'laila Pereira [mailto:dlailap@home.com]
Sent: Sunday, February 17, 2002 11:52 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] all tables in a DB\?


What SQL command can I issue in Postgresql to list all the tables in a
database?





---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

select * from pg_table;

Chris

> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of D'laila Pereira
> Sent: Monday, 18 February 2002 3:52 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] all tables in a DB\?
> 
> 
> What SQL command can I issue in Postgresql to list all the tables in a
> database?
> 
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>