Re: database and table listing

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