Skip site navigation (1) Skip section navigation (2)

RE: exploring data

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: (view raw or whole 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..


-----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
Diamond Bullet Design -

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

pgsql-novice by date

Next:From: Willie NorthwayDate: 2001-06-27 18:34:20
Subject: Re: exploring data
Previous:From: harroldDate: 2001-06-27 18:28:21
Subject: Re: exploring data

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group