RE: exploring data

type \? for a list of all the \ commands.. one of them will give you how to
list the DB's and another will show you how to list the tables.. I know it's
kinda different.. I come from a SQL7 world..

Travis

-----Original Message-----
From: Willie Northway [mailto:willn@diamondbullet.com]
Sent: Wednesday, June 27, 2001 1:18 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] exploring data



Hello, I'm a mysql user who's trying to learn postgres. How would I
explore which databases or tables are available for use?

If I were using mysql, I would try something like this:

mysql> show databases;
mysql> use test;
mysql> show tables;

How would I accomplish something like this in postgres?

- Willie

----
Willie Northway - Software Developer http://www.willienorthway.com/
Diamond Bullet Design - http://www.diamondbullet.com


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl