CopyManager(In/out) vs. delete/insert directly - Mailing list pgsql-general

From Emi Lu
Subject CopyManager(In/out) vs. delete/insert directly
Date
Msg-id 544024D5.7020301@encs.concordia.ca
Whole thread Raw
List pgsql-general
<small>Hello, <br /><br /> Two options for data (>1M), may I know which one better please? <br /><br /> (1) copyOut
(JDBCcopyManager) <br />      t1 into a.csv <br />      delete t2 where pk.cols in t1 <br />      copyIn t2 from a.csv
<br/><br /> (2) setautoCommit(false); <br />      delete t2 where pk.cols in t1; <br />      insert t2 select * from
t1;<br /><br /> Thank you <br /> Emi </small><br /> 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Tables used in query not listed in EXPLAIN
Next
From: Adrian Klaver
Date:
Subject: Re: Any postgres API available to get errorcode for PQerrorMessage