Re: newbie qs; examining databases and tables

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@perrin.socsci.unc.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
>