postgres equivalent's

Patrick Fleming EA plug-discuss@lists.plug.phoenix.az.us
Sat, 14 Jun 2003 12:04:02 -0700 (MST)


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 - PLUG-discuss@lists.plug.phoenix.az.us
> 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