Re: How to just "link" to some data feed - Mailing list pgsql-jdbc

From tivvpgsqljdbc@gtech-ua.com
Subject Re: How to just "link" to some data feed
Date
Msg-id 48465209.2060900@gtech-ua.com
Whole thread Raw
In response to How to just "link" to some data feed  ("Albretch Mueller" <lbrtchx@gmail.com>)
List pgsql-jdbc
Hello.

I'd recommend you to have some intermediate (temporary?) 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 temporary table.


pgsql-jdbc by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: How to just "link" to some data feed
Next
From: Pushker Chaubey
Date:
Subject: trouble with regular expression