Re: SQL Command - To List Tables ?

From: sector119(at)mail(dot)ru
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SQL Command - To List Tables ?
Date: 2003-08-27 11:51:42
Message-ID: 20030827115142.GA2284@city.gov.te.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Is there a SQL command I can issue which will list all the TABLES within
> a database ?

select datname from pg_database;

--
WBR, sector119

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-08-27 11:56:05 Re: Database recovery after fs crash
Previous Message Martijn van Oosterhout 2003-08-27 11:47:23 Re: Database recovery after fs crash