Re: [ADMIN] Dumping partial database content

2004-07-02 Thread Bender, Cheryl
ECTED] Subject: Re: [ADMIN] Dumping partial database content Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Bender, Cheryl") wrote: > Just wondering--is it possible to dump on a temporary table? The temp table is only visible inside the context of the transaction

Re: [ADMIN] Dumping partial database content

2004-07-02 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Bender, Cheryl") wrote: > Just wondering--is it possible to dump on a temporary table? The temp table is only visible inside the context of the transaction under which it was created. A pg_dump session will create an independent tra

Re: [ADMIN] Dumping partial database content

2004-07-02 Thread Bender, Cheryl
, Cheryl Sent: Friday, July 02, 2004 11:48 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Dumping partial database content Just wondering--is it possible to dump on a temporary table? Cheryl Bender -Original Message- From: [EMAIL PROTECTED] [mailto

Re: [ADMIN] Dumping partial database content

2004-07-02 Thread Bender, Cheryl
Just wondering--is it possible to dump on a temporary table? Cheryl Bender -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of mike g Sent: Thursday, July 01, 2004 11:11 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Dumping partial

Re: [ADMIN] Dumping partial database content

2004-07-01 Thread mike g
I don't believe there is an option in pg_dump that current handles that. It is the whole table / object or nothing at all. Depending on the volume of transactions and frequency that you need to dump the data will determine which solution works best for you. Heavy volume and/or dumps multiple tim