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

Поиск
Список
Период
Сортировка
От tivvpgsqljdbc@gtech-ua.com
Тема Re: How to just "link" to some data feed
Дата
Msg-id 48465209.2060900@gtech-ua.com
обсуждение исходный текст
Ответ на How to just "link" to some data feed  ("Albretch Mueller" <lbrtchx@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: How to just "link" to some data feed
Следующее
От: Pushker Chaubey
Дата:
Сообщение: trouble with regular expression