Re: SQL Command - To List Tables ?

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: pgmoscatt(at)optushome(dot)com(dot)au
Cc: "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL Command - To List Tables ?
Date: 2003-08-27 11:46:05
Message-ID: 20030827124605.A22181@bacon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 |
+------------------------------+---------------------------------------------+

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-08-27 11:47:23 Re: Database recovery after fs crash
Previous Message Jan Wieck 2003-08-27 11:31:48 Re: move to usenet?