From: | Andrew Perrin <clists(at)perrin(dot)socsci(dot)unc(dot)edu> |
---|---|
To: | Rusty Wright <rusty(at)socrates(dot)berkeley(dot)edu> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: newbie qs; examining databases and tables |
Date: | 2002-10-21 13:14:34 |
Message-ID: | Pine.LNX.4.21.0210210913090.28800-100000@perrin.socsci.unc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
SHOW DATABASES --> \l
USE DB1 --> \c db1
SHOW TABLES --> \d
DESCRIBE TABLE1 --> \d table1
ap
----------------------------------------------------------------------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
clists(at)perrin(dot)socsci(dot)unc(dot)edu * andrew_perrin (at) unc.edu
On Tue, 15 Oct 2002, Rusty Wright wrote:
> I'm someone with some mysql experience and need to set up postgres for
> a product we're evaluating. In mysql I can use SHOW DATABASES to list
> all of the databases on the system, USE DB1 to switch to one of the
> databases, SHOW TABLES to list all of the table names in the database
> I'm USEing, and DESCRIBE TABLE1 to list all of the column names, data
> types, etc. for a table.
>
> How do I do the equivalent with postgresql? Are there equivalent SQL
> commands?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff | 2002-10-21 16:24:21 | Re: Optimizing DB Permormanance |
Previous Message | Pandurang | 2002-10-21 08:00:21 | Optimizing DB Permormanance |