Re: fine tuned database dump/reload?

The TODO has has an open item to all multiple -t options and other
complexity.

---------------------------------------------------------------------------

Dan Armbrust wrote:
> 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/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073