From: | "Williams, Travis L, NPONS" <tlw(at)att(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | RE: exploring data |
Date: | 2001-06-27 18:29:24 |
Message-ID: | C9AA291109D8D311BE15009027AD06CF05B362A8@mo3980po14.ems.att.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)diamondbullet(dot)com]
Sent: Wednesday, June 27, 2001 1:18 PM
To: pgsql-novice(at)postgresql(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Willie Northway | 2001-06-27 18:34:20 | Re: exploring data |
Previous Message | harrold | 2001-06-27 18:28:21 | Re: exploring data |