Re: List tables in the database

From: Tom Jenkins <tjenkins(at)devis(dot)com>
To: Varsha Agarwal <varsha_agarwal(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: List tables in the database
Date: 2002-07-26 00:34:43
Message-ID: 3D409923.9050704@devis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavin M. Roy 2002-07-26 00:41:39 Re: List tables in the database
Previous Message Christian H. Stork 2002-07-26 00:22:27 Re: List tables in the database