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