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@xxxxxxxxxxxx
End Point Corporation
That's excellent news! I've needed this feature for a while now too.
Regards
Ron St.Pierre
