Re: database and table listing - Mailing list pgsql-general

From Richard Poole
Subject Re: database and table listing
Date
Msg-id 20001101191616.S21112@office.vi.net
Whole thread Raw
In response to database and table listing  (steve@foxx.uklinux.net (Stephen Patterson))
Responses Re: database and table listing
List pgsql-general
On Wed, Nov 01, 2000 at 07:00:12PM +0000, Stephen Patterson wrote:
> are there any SQL statements which I can type into the psql client to give
> a listing of available databases,

\l

available tables (within a database),

\d

> and to view the structure of a single table.

\d tablename


All of which is in "man psql"...

These aren't SQL statements themselves, but if you start psql with
"-E", you can see the SQL queries which are sent to the backend when
you use them.

Richard

pgsql-general by date:

Previous
From: Marko Kreen
Date:
Subject: Re: database and table listing
Next
From: Charles Tassell
Date:
Subject: Two Postmasters on the Same Machine