pg_dump question

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.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

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.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Alvaro Herrera <alvherre@commandprompt.com> schrieb:

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.

Yes, of course. Ref. integrity, for instance. But i don't know, how 8.2
solve this problem. Can you explain this?

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�

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

Andreas Kretschmer wrote:

Alvaro Herrera <alvherre@commandprompt.com> schrieb:

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.

Yes, of course. Ref. integrity, for instance. But i don't know, how 8.2
solve this problem. Can you explain this?

It dumps all tables in a single SERIALIZABLE transaction.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support