Re: newbie qs; examining databases and tables - Mailing list pgsql-admin

From Andrew Perrin
Subject Re: newbie qs; examining databases and tables
Date
Msg-id Pine.LNX.4.21.0210210913090.28800-100000@perrin.socsci.unc.edu
Whole thread Raw
In response to newbie qs; examining databases and tables  (Rusty Wright <rusty@socrates.Berkeley.EDU>)
Responses Re: newbie qs; examining databases and tables
List 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@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
>


pgsql-admin by date:

Previous
From: pandurang@manas-solutions.com (Pandurang)
Date:
Subject: Optimizing DB Permormanance
Next
From: Jeff
Date:
Subject: Re: Optimizing DB Permormanance