postgres equivalent's

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Mike Starke
Date:  
Subject: postgres equivalent's
On Sat, Jun 14, 2003 at 10:07:31AM -0700, Nick Estes wrote:
/_-----BEGIN PGP SIGNED MESSAGE-----
/_Hash: SHA1
/_
/_> mysqlshow
/_
/_If you tell me what it does, I'm sure I could tell you the equivalent (-=
/_

mysqlshow displays a list of all databases on the server.

Thanks for the remaining commands: Postgres may not be as evil/hard
as my initial impression.

I did read an article last night where the author gave
a really nice comparison...wished I would have saved the URL.
One thing he mentioned was that when Postgres went down,
it goes does hard. Corrupted db files/indexes/etc in Postgres
are not fun....which leads me to my last command question:

In mysql there is a program called mysqldump, which I use
each night to backup all of my databases. It simply dumps
the contents of the database to a sql file that can be read back in.

Postgres equivalent?

-mike