postgres equivalent's

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Patrick Fleming EA
Date:  
Subject: postgres equivalent's
On Sat, 14 Jun 2003, Mike Starke wrote:

> /_> mysqlshow
> /_
> mysqlshow displays a list of all databases on the server.
>

\l
will list all the DBs. Don't know how to call it from the CLI.
> 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?
>


pg_dump
pg_dumpall

> -mike
>
>
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>


--
Patrick Fleming, EA
Licensed to represent taxpayers
before Exam, Appeals, and Conference
divisions of the IRS