Re: Get list of tables in a database

From: Oskar Berggren <beo(at)sgs(dot)o(dot)se>
To: Riyaz(at)umapinc(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Get list of tables in a database
Date: 2002-12-03 20:58:41
Message-ID: 3DED1B01.8060805@sgs.o.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Riyaz(at)umapinc(dot)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(at)sgs(dot)o(dot)se |
| Network and Software Engineer SGS Datanätgrupp |
| Gothenburg, Sweden |
\----------------------------------------------------------------------/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message wsheldah 2002-12-03 21:01:26 Re: Postgresql -- initial impressions and comments
Previous Message Bruce Momjian 2002-12-03 20:52:19 Re: getting query result into a file