for documentation of the command line interface to PostgreSQL you may look
at the docs for psql (client applications)
One of the commands, you are looking for, is "\d". Equivalent to "show
More informations can be found in the system catalogs (or system tables) of
docs are at:
So "select * from pg_database;" should be equivalent to MySQL's "show
----- Original Message -----
From: jim davis
Sent: Friday, July 13, 2001 5:44 PM
Subject: [NOVICE] Silly newbie questions
Ok, I was directed that I would be taking over an old mac based database
and was told that we would be moving to a SQL based DB. I looked into
MySQL (sorry, I know thats a bad word around these parts :) )and sorta
got into it. Well, I saw the light and have decided to move to
PstgreSQL. I have downloaded and installed on my SuSE linux server the
latest version (7.1.2) and got it to work... But I have noticed some
differences (duh) that I can't find answers for in the online docs.
In the command line interface in MySQL, if I wanted to see all the
databases on my server, or if I wanted to see all the tables in a given
database, I would type "show databases" or "show tables" but that
doesnt seem to work in PostgreSQL...
Also, is there a painless way to get all of my MySQL databases and data
moved over to PostgreSQL?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
In response to
pgsql-novice by date
|Next:||From: GH||Date: 2001-07-13 18:46:46|
|Subject: Re: Silly newbie questions|
|Previous:||From: jim davis||Date: 2001-07-13 15:44:44|
|Subject: Silly newbie questions|