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.
_______________________________
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? |