postgres equivalent's

Mike Starke plug-discuss@lists.plug.phoenix.az.us
Sat, 14 Jun 2003 13:52:58 -0500


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