Thread: List tables in the database

Hi,
I want to see the list of all the tables in the database. Can anyone tell me
how to do that? I tried show table but thats not working.
-Varha

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Varsha Agarwal wrote:
> Hi,
> I want to see the list of all the tables in the database. Can anyone
> tell me how to do that? I tried show table but thats not working.
> -Varha
>

select * from pg_tables;

Tom

Or in psql try "\d"

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Jenkins
Sent: Thursday, July 25, 2002 5:35 PM
To: Varsha Agarwal
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] List tables in the database

Varsha Agarwal wrote:
> Hi,
> I want to see the list of all the tables in the database. Can anyone
> tell me how to do that? I tried show table but thats not working.
> -Varha
>

select * from pg_tables;

Tom



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Try \? at the psql prompt to find out about \d and family.

--
Chris Stork (PhD student at UC Irvine)  http://www.ics.uci.edu/~cstork/
OpenPGP fingerprint: B08B 602C C806 C492 D069  021E 41F3 8C8D 50F9 CA2F