Re: fine tuned database dump/reload? - Mailing list pgsql-general

From Bricklen Anderson
Subject Re: fine tuned database dump/reload?
Date
Msg-id 434BE99E.3070509@PresiNET.com
Whole thread Raw
In response to fine tuned database dump/reload?  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
Responses Re: fine tuned database dump/reload?  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
List pgsql-general
Dan Armbrust wrote:
> Does postgresql have any facility to dump anything more fine grained
> than a database to a text file?
>
> For example, to mention a bad word, MySQL's dump command allows you to
> specify individual tables to dump
<snip>
> PostgreSQL's pg_dump command seems rather limited in its abilities.
> Maybe I'm missing the command I'm looking for.
>
> Thanks,
>
> Dan
>

pg_dump --help
...
  -n, --schema=SCHEMA      dump the named schema only
  -s, --schema-only        dump only the schema, no data
  -t, --table=TABLE        dump the named table only
...

--
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________

pgsql-general by date:

Previous
From: Zlatko Matić
Date:
Subject: Re: user privilages for executing pg_autovacuum?
Next
From: Scott Marlowe
Date:
Subject: Re: Cluster/redundancy question