Re: fine tuned database dump/reload?

From: Bricklen Anderson <BAnderson(at)PresiNET(dot)com>
To: Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: fine tuned database dump/reload?
Date: 2005-10-11 16:34:38
Message-ID: 434BE99E.3070509@PresiNET.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
_______________________________

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Youngblood 2005-10-11 16:37:46 Re: PostgreSQL missing in SuSE 10?
Previous Message Zlatko Matić 2005-10-11 16:34:23 Re: user privilages for executing pg_autovacuum?