Re: pg_dump schma while excluding specific table

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

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://www.postgresql.org/docs/9.0/interactive/app-pgdump.html

"Note: The behavior of the -t switch is not entirely upward compatible with
pre-8.2 PostgreSQL versions. Formerly, writing -t tab would dump all tables
named tab, but now it just dumps whichever one is visible in your default search
path. To get the old behavior you can write -t '*.tab'. Also, you must write
something like -t sch.tab to select a table in a particular schema, rather than
the old locution of -n sch -t tab. "

While the above shows -t the same applies to -T.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mario Weilguni 2011-11-03 20:07:59 Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!
Previous Message hubert depesz lubaczewski 2011-11-03 20:03:12 Re: Strange problem with create table as select * from table;