| From: | Tony Capobianco <tcapobianco(at)prospectiv(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump schma while excluding specific table |
| Date: | 2011-11-03 19:54:35 |
| Message-ID: | 1320350075.1970.8.camel@tony1.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm using 9.0.3. I've tried several permutations of this script and
still I get a dump of the entire schema. The corgi table is still
included when I need it excluded.
On Thu, 2011-11-03 at 12:02 -0700, Adrian Klaver wrote:
> On Thursday, November 03, 2011 8:16:42 am Tony Capobianco wrote:
> > When I issue:
> >
> > pg_dump newdb > /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2>
> > /DUMPDIR/newdb.log
> >
> > I get a dump of the entire dev schema. My goal is to dump the dev
> > schema minus the corgi table. How can I adjust my script to perform
> > this function?
>
> A test here worked:
> pg_dump -n public -T csv_null -U postgres -Fc -f test.out test
>
> This is for Postgres version 9.0.4, what version are you using?
>
> >
> > Thanks.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ioana Danes | 2011-11-03 19:56:49 | Re: pg_dump schma while excluding specific table |
| Previous Message | Adrian Klaver | 2011-11-03 19:02:55 | Re: pg_dump schma while excluding specific table |