Re: fine tuned database dump/reload?

Dan Armbrust wrote:
> Bricklen Anderson wrote:
>
>>
>> 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
>> ...
>>
>
> Just after I sent the e-mail, I realized that I forgot that I saw that
> option - but on my first reading of the description (and being and
> annoying user who didn't try it first) it didn't appear that it would
> allow me to specify more than one table.
>
> But I tested it, and it does let me specify the -t command more than
> once.  So that gets me past that issue.
>
> Dan
>
>
Now I'm just filling the mailing list with mis-information.  It actually
ignores all but the last -t flag - so this only allows me to specify one
table at a time, rather than several tables.

I need to write up my use case so the maintainers can see why I want to
be able to dump things in such a specific way - its not for backup
purposes - so I'm kind of misusing the intent of the tool.  More info in
a bit.

Dan



--
****************************
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/