Postgres Pro
Downloads
Home   >   mailing lists

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

From Robby Russell
Subject Re: SQL Command - To List Tables ?
Date
Msg-id 3F4CAAD2.3040309@commandprompt.com
Whole thread Raw
In response to SQL Command - To List Tables ?  (Peter Moscatt <pgmoscatt@optushome.com.au>)
Responses Re: SQL Command - To List Tables ?  (Jeffrey Melloy <jmelloy@visualdistortion.org>)
List pgsql-general
Tree view 
Peter Moscatt wrote:

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

Well, when you are the postgres commandline client, you can type
  #  \dt

That will show all the tables in your current database.


--
Robby Russell,  |  Sr. Administrator / Lead Programmer
Command Prompt, Inc.   |  http://www.commandprompt.com
rrussell@commandprompt.com | Telephone: (503) 222.2783

pgsql-general by date:

Previous
From: Peter Moscatt
Date:
Subject: SQL Command - To List Tables ?
Next
From: "Bruno BAGUETTE"
Date:
Subject: RE : mysql's last_insert_id