Get list of tables in a database

From: Riyaz(at)umapinc(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Get list of tables in a database
Date: 2002-12-03 20:12:08
Message-ID: OFBA0497FF.759D317D-ON05256C84.006EAE9D-85256C84.006EDFB8@umapinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2002-12-03 20:24:41 Re: PostgreSQL in Universities (Was: Re: 7.4 Wishlist)
Previous Message Magnus Naeslund(f) 2002-12-03 20:09:10 Re: Postgresql -- initial impressions and comments