Re: [GENERAL] pg_dump schma while excluding specific table

2011-11-03 Thread Tony Capobianco
BINGO! Thanks everyone. That did the trick! On Thu, 2011-11-03 at 12:56 -0700, Ioana Danes wrote: > > > > > pg_dump newdb > /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2> > > /DUMPDIR/newdb.log > > > > Try: -T dev.corgi instead of -T corgi > > -- Sent via pgsql-general mailing list

Re: [GENERAL] pg_dump schma while excluding specific table

2011-11-03 Thread Adrian Klaver
On Thursday, November 03, 2011 12:54:35 pm Tony Capobianco wrote: > 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. You may be getting bit by search path issues: http://ww

Re: [GENERAL] pg_dump schma while excluding specific table

2011-11-03 Thread Ioana Danes
> > pg_dump newdb > /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2> > /DUMPDIR/newdb.log > Try: -T dev.corgi  instead of -T corgi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_dump schma while excluding specific table

2011-11-03 Thread Tony Capobianco
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: > > W

Re: [GENERAL] pg_dump schma while excluding specific table

2011-11-03 Thread Adrian Klaver
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 sc

Re: [GENERAL] pg_dump schma while excluding specific table

2011-11-03 Thread Greg Williamson
Tony -- > 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? > > Thanks. Maybe

[GENERAL] pg_dump schma while excluding specific table

2011-11-03 Thread Tony Capobianco
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? Thanks. -- Sent via pgsql-general mailing l