Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Jdbc > Re: How to just...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 9 of 9 Topic 1967 of 2010
Post > Topic >>

Re: How to just "link" to some data feed

by tivvpgsqljdbc@[EMAIL PROTECTED] Jun 4, 2008 at 11:27 AM

Hello.

I'd recommend you to have some intermediate (tem****ary?) table to load 
data to and then sync data to main table using simple insert statement.
The call list would look like
copy  temptbl FROM '/tmp/codigos_postales.csv' DELIMITERS ',' CSV;
insert into maintbl select * from temptbl where cp not in (select cp 
from maintbl)
delete from temptbl;
commit;

P.S. Last step is not needed if you use tem****ary table.


-- 
Sent via pgsql-jdbc mailing list (pgsql-jdbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
 




 9 Posts in Topic:
How to just "link" to some data feed
lbrtchx@[EMAIL PROTECTED]  2008-06-03 20:04:10 
Re: How to just "link" to some data feed
pg@[EMAIL PROTECTED] (Da  2008-06-03 20:24:47 
Re: How to just "link" to some data feed
lbrtchx@[EMAIL PROTECTED]  2008-06-03 22:59:49 
Re: How to just "link" to some data feed
oliver@[EMAIL PROTECTED]   2008-06-04 15:03:49 
Re: How to just "link" to some data feed
tgl@[EMAIL PROTECTED] (T  2008-06-04 00:16:22 
Re: How to just "link" to some data feed
lbrtchx@[EMAIL PROTECTED]  2008-06-03 23:58:41 
Re: How to just "link" to some data feed
oliver@[EMAIL PROTECTED]   2008-06-04 16:04:13 
Re: How to just "link" to some data feed
heikki@[EMAIL PROTECTED]   2008-06-04 11:19:08 
Re: How to just "link" to some data feed
tivvpgsqljdbc@[EMAIL PROT  2008-06-04 11:27:53 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Aug 21 22:42:01 CDT 2008.