Re: SQL Command - To List Tables ?

From: Robby Russell <rrussell(at)commandprompt(dot)com>
To:
Cc: "\"PostgreSQL [GENERAL] \" List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL Command - To List Tables ?
Date: 2003-08-27 12:57:54
Message-ID: 3F4CAAD2.3040309@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)commandprompt(dot)com | Telephone: (503) 222.2783

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-08-27 12:59:15 Re: deleting referenced data
Previous Message Martijn van Oosterhout 2003-08-27 12:48:09 Re: Weird psql problem