Postgres Pro
Downloads
Home   >   mailing lists

Re: all tables in a DB\? - Mailing list pgsql-sql

From Rolf Hug
Subject Re: all tables in a DB\?
Date
Msg-id a4ro0l$1641$1@jupiter.hub.org
Whole thread Raw
In response to all tables in a DB\?  ("D'laila Pereira" <dlailap@home.com>)
List pgsql-sql
Tree view 
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?
>
>
>
>

pgsql-sql by date:

Previous
From: ishapiro@cogitations.com (Irv Shapiro)
Date:
Subject: Casting pairs of floating point variables as a point in plpgsql
Next
From: Tom Lane
Date:
Subject: Re: Why is my index not used