Re: pg_dump schma while excluding specific table - Mailing list pgsql-general

From Tony Capobianco
Subject Re: pg_dump schma while excluding specific table
Date
Msg-id 1320350075.1970.8.camel@tony1.localdomain
Whole thread Raw
In response to Re: pg_dump schma while excluding specific table  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: pg_dump schma while excluding specific table  (Adrian Klaver <adrian.klaver@gmail.com>)
List 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.
>



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_dump schma while excluding specific table
Next
From: Ioana Danes
Date:
Subject: Re: pg_dump schma while excluding specific table