Re: Excluding a table from pg_dump

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@turnstep.com
> End Point Corporation
>

That's excellent news! I've needed this feature for a while now too.

Regards

Ron St.Pierre