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
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; |