Re: database and table listing

From: Richard Poole <richard(dot)poole(at)vi(dot)net>
To: Stephen Patterson <steve(at)foxx(dot)uklinux(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: database and table listing
Date: 2000-11-01 19:16:16
Message-ID: 20001101191616.S21112@office.vi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marko Kreen 2000-11-01 19:17:14 Re: database and table listing
Previous Message Marc SCHAEFER 2000-11-01 19:15:01 Re: Increasing Table Column Size in 7.0 Syntax