Re: exploring data - Mailing list pgsql-novice

From Willie Northway
Subject Re: exploring data
Date
Msg-id Pine.LNX.4.10.10106271430500.25110-100000@spiderman.diamondbullet.com
Whole thread Raw
In response to Re: exploring data  (harrold@sage.che.pitt.edu)
List pgsql-novice
On Wed, 27 Jun 2001 harrold@sage.che.pitt.edu wrote:

> normally when postgres is started you tell it the database.

Is there a way to just start the postgres client, and switch databases
after seeing what is available? Or would I have to connect using a dummy
database, browse, then switch?

> then to show the tables
> dbname=# \d

this definitely helps, thanks.

> i dont know how to list the available databaes.

I started browsing the source code, and found \l (as in L) lists the
databases.

- Willie



pgsql-novice by date:

Previous
From: "Williams, Travis L, NPONS"
Date:
Subject: RE: exploring data
Next
From: Willie Northway
Date:
Subject: Re: exploring data