Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL Command - To List Tables ? - Mailing list pgsql-general

From Paul Thomas
Subject Re: SQL Command - To List Tables ?
Date
Msg-id 20030827124605.A22181@bacon
Whole thread Raw
In response to SQL Command - To List Tables ?  (Peter Moscatt <pgmoscatt@optushome.com.au>)
List pgsql-general
Tree view 
On 27/08/2003 11:37 Peter Moscatt wrote:
> Is there a SQL command I can issue which will list all the TABLES within
> a database ?
>
> Pete


select tablename from pg_tables

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Database recovery after fs crash
Next
From: Jan Wieck
Date:
Subject: Re: move to usenet?