-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > 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 PGP Key: 0x14964AC8 200608150821 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFE4bxzvJuQZxSWSsgRAgYPAJ9qa/jE5oHY/DMOGNfuHsoVgiwf4gCgjnHW FqZF5l51h4j/ul+dK7M90DE= =VSi/ -----END PGP SIGNATURE-----
