Re: Problems with pg_dump and -t wildcards

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with pg_dump and -t wildcards
Date: 2008-07-25 19:21:33
Message-ID: 20080725192132.GI29775@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Bond-Caron 2008-07-25 19:43:31 Re: php + postgresql
Previous Message Tom Lane 2008-07-25 19:08:43 Re: Problems with pg_dump and -t wildcards