From: | Ron St-Pierre <ron(dot)pgsql(at)shaw(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Excluding a table from pg_dump |
Date: | 2006-08-15 14:44:29 |
Message-ID: | 44E1DDCD.4010201@shaw.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Greg Sabino Mullane wrote:
>> The database contains several schemas and excluding "comment_archive" by
>> moving it to different schema doesn't sound very convenient. pg_dump
>> doesn't have an option to dump multiple schemas at once.
>>
>> Are there any working "-X" patches for pg_dump or does anyone have other
>> possible solutions?
>>
>
> The next version of Postgres (8.2) will have the ability to do everything
> you want. It's active now in cvs, if you want to try it out. You can exclude
> one or more tables with the -T flag, and can include or exclude schemas
> with the -n and -N resepectively. Any of the four flags can be used multiple
> times, and they all accept POSIX-style regular expressions as well.
>
> - --
> Greg Sabino Mullane greg(at)turnstep(dot)com
> End Point Corporation
>
That's excellent news! I've needed this feature for a while now too.
Regards
Ron St.Pierre
From | Date | Subject | |
---|---|---|---|
Next Message | Ludwig Isaac Lim | 2006-08-15 16:05:14 | Unable to Start PostgreSQL 8.1.4 on Windows XP |
Previous Message | Michael Meskes | 2006-08-15 13:56:03 | Re: Connection string |