Re: pg_dump schma while excluding specific table

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Tony Capobianco <tcapobianco(at)prospectiv(dot)com>
Subject: Re: pg_dump schma while excluding specific table
Date: 2011-11-03 19:02:55
Message-ID: 201111031202.56380.adrian.klaver@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Capobianco 2011-11-03 19:54:35 Re: pg_dump schma while excluding specific table
Previous Message Greg Williamson 2011-11-03 18:46:10 Re: pg_dump schma while excluding specific table