Get list of tables in a database

% psql -E dbname
dbname=>\d

at the beginning of the output it will print out the query used to
generate the table list.

-E, --echo-hidden
Echoes the actual queries generated by \d and other
backslash commands. You can use this if you wish
to include similar functionality into your own pro-
grams. This is equivalent to setting the variable
ECHO_HIDDEN from within psql.

On Tue, 3 Dec 2002 Riyaz@umapinc.com wrote:

Riyaz@umapinc.com wrote:

Hi,

I am looking for a SQL query which will return me the names of all
the tables in a database. I want to use this in my php page to generate
a list of tables given the name of database.

Thanks in advance,
Riyaz

See FAQ item 4.3.

/Oskar

--
/----------------------------------------------------------------------\
| Oskar Berggren beo@sgs.o.se |
| Network and Software Engineer SGS Datan�tgrupp |
| Gothenburg, Sweden |
\----------------------------------------------------------------------/

There is a relation called pg_class in PostgreSQL, but it contains not only
tables, but also contains views and probably more. Check it.

G.
--
while (!asleep()) sheep++;

---------------------------- cut here ------------------------------
----- Original Message -----
From: <Riyaz@umapinc.com>
Sent: Tuesday, December 03, 2002 9:12 PM