From: Rolf Hug <rolfhug@bluewin.ch>
To: pgsql-sql@postgresql.org
Subject: Re: all tables in a DB\?
Date: Mon, 18 Feb 2002 21:28:15 +0100
Message-ID: <a4ro0l$1641$1@jupiter.hub.org> (raw)
References: <Xh2c8.20270$tg4.228609@vixen.cso.uiuc.edu>
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?
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rolfhug@bluewin.ch
Subject: Re: all tables in a DB\?
In-Reply-To: <a4ro0l$1641$1@jupiter.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox