Re: pg_dump question

-----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-----