-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 11/02/06 09:56, Alvaro Herrera wrote: > A. Kretschmer wrote: >> am Wed, dem 01.11.2006, um 13:50:58 -0800 mailte Thomas Burns folgendes: >>> Hi, >>> >>> I would like to use pg_dump to backup a list of tables to one file, >>> but it looks like >>> the -t option only supports one file. So, pg_dump gives you the >>> option of backing >>> up and entire database or one file, but nothing in between. Am I >>> missing something? >>> Is there a way to backup multiple tables (but not the whole database)? >> You can wait for 8.2, this version supports multiple -t - options. >> Or you can concat several table-dumps to one big dump. > > Note that the latter option does not guarantee that you get a consistent > dump. What about creating a new schema that "just" has views back to the base tables you want to dump. Then pg_dump the schema. - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFSheIS9HxQb37XmcRAh87AKDnrDQj2sL/J8kv1+ZEz/7Ml4mb1QCglkc0 IfDD3/ISk7Jew8hdtpSyWNI= =1pD9 -----END PGP SIGNATURE-----
