Re: [ADMIN] Dump only part of a DB

2004-06-09 Thread Bruce Momjian
Tom Lane wrote: > "David F. Skoll" <[EMAIL PROTECTED]> writes: > > pg_dump can be used to dump an entire database, or just a single > > table. Is there a way to make a consistent dump of more than one > > table, but less than all of the tables in the database? > > This has been discussed before,

Re: [ADMIN] Dump only part of a DB

2004-06-09 Thread Tom Lane
"David F. Skoll" <[EMAIL PROTECTED]> writes: > pg_dump can be used to dump an entire database, or just a single > table. Is there a way to make a consistent dump of more than one > table, but less than all of the tables in the database? This has been discussed before, and I think we had agreed th

Re: [ADMIN] Dump only part of a DB

2004-06-09 Thread Bill Montgomery
Scott Marlowe wrote: On Wed, 2004-06-09 at 10:43, David F. Skoll wrote: On Wed, 9 Jun 2004, Scott Marlowe wrote: If you put the application's data into a specific schema, then you can dump just that schema with the -n switch... Thanks. That's a solution for 7.4, but some of our inst

Re: [ADMIN] Dump only part of a DB

2004-06-09 Thread Scott Marlowe
On Wed, 2004-06-09 at 10:43, David F. Skoll wrote: > On Wed, 9 Jun 2004, Scott Marlowe wrote: > > > If you put the application's data into a specific schema, then you can > > dump just that schema with the -n switch... > > Thanks. That's a solution for 7.4, but some of our installed base > (espe

Re: [ADMIN] Dump only part of a DB

2004-06-09 Thread David F. Skoll
On Wed, 9 Jun 2004, Scott Marlowe wrote: > If you put the application's data into a specific schema, then you can > dump just that schema with the -n switch... Thanks. That's a solution for 7.4, but some of our installed base (especially the older ones with large DB's that cause the problem) are

Re: [ADMIN] Dump only part of a DB

2004-06-09 Thread Scott Marlowe
On Wed, 2004-06-09 at 08:09, David F. Skoll wrote: > Hi, > > pg_dump can be used to dump an entire database, or just a single > table. Is there a way to make a consistent dump of more than one > table, but less than all of the tables in the database? Doing a bunch > of single-table pg_dumps isn'

[ADMIN] Dump only part of a DB

2004-06-09 Thread David F. Skoll
Hi, pg_dump can be used to dump an entire database, or just a single table. Is there a way to make a consistent dump of more than one table, but less than all of the tables in the database? Doing a bunch of single-table pg_dumps isn't really an option, because some tables may change during the d