newbie qs; examining databases and tables

From: Rusty Wright <rusty(at)socrates(dot)Berkeley(dot)EDU>
To: pgsql-admin(at)postgresql(dot)org
Subject: newbie qs; examining databases and tables
Date: 2002-10-15 23:16:53
Message-ID: 200210152316.g9FNGrJ13954@socrates.Berkeley.EDU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rusty Wright 2002-10-15 23:27:38 newbie qs; examining databases and tables
Previous Message Marc Mitchell 2002-10-15 22:43:08 Re: How do I restore data changes made after the backup?