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

Re: Silly newbie questions

From: A_Schnabel(at)t-online(dot)de (Andre Schnabel)
To: "ML: Postgres Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Silly newbie questions
Date: 2001-07-13 18:21:40
Message-ID: 008601c10bc8$aa607f20$0201a8c0@aschnabel.homeip.net (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

for documentation of the command line interface to PostgreSQL you may look
at the docs for psql (client applications)
http://www.postgresql.org/idocs/index.php?app-psql.html

One of the commands, you are looking for, is "\d". Equivalent to "show
tables".

More informations can be found in the system catalogs (or system tables) of
PostgreSQL.
docs are at:
http://www.postgresql.org/idocs/index.php?catalogs.html

So "select * from pg_database;" should be equivalent to MySQL's "show
databases"

CU,
Andre

----- Original Message -----
From: jim davis
To: 'pgsql-novice(at)postgresql(dot)org'
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?

thanks!
-Jim


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


In response to

pgsql-novice by date

Next:From: GHDate: 2001-07-13 18:46:46
Subject: Re: Silly newbie questions
Previous:From: jim davisDate: 2001-07-13 15:44:44
Subject: Silly newbie questions

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