Re: Problems with pg_dump and -t wildcards - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Problems with pg_dump and -t wildcards
Date
Msg-id 20080725192132.GI29775@commandprompt.com
Whole thread Raw
In response to Problems with pg_dump and -t wildcards  (Bill Thoen <bthoen@gisnet.com>)
List pgsql-general
On Fri, Jul 25, 2008 at 11:36:14AM -0600, Bill Thoen wrote:
> I'm having some problems with pg_dump and the -t switch. I can't get it to
> work using wildcards nor with multiple -t switches. I'm using PostgreSQL
> 8.1.5 and trying to dump just a table and its associated sequence.

You can't do that.  The ability to specify multiple -t switches came
in 8.2.

You can work around this if you have a custom dump format, by just
restoring the tables you want using pg_restore.  This is a pretty
hideous workaround, though.

A

--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with pg_dump and -t wildcards
Next
From: "Jonathan Bond-Caron"
Date:
Subject: Re: php + postgresql