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(at)umapinc(dot)com>
Sent: Tuesday, December 03, 2002 9:12 PM
> 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