| From: | Willie Northway <willn(at)diamondbullet(dot)com> |
|---|---|
| To: | harrold(at)sage(dot)che(dot)pitt(dot)edu |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: exploring data |
| Date: | 2001-06-27 18:34:20 |
| Message-ID: | Pine.LNX.4.10.10106271430500.25110-100000@spiderman.diamondbullet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, 27 Jun 2001 harrold(at)sage(dot)che(dot)pitt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willie Northway | 2001-06-27 21:25:55 | Re: exploring data |
| Previous Message | Williams, Travis L, NPONS | 2001-06-27 18:29:24 | RE: exploring data |