Michael Glaesemann wrote:
On Dec 24, 2007, at 22:03 , fdu.xiaojf@xxxxxxxxx wrote:
I have googled and currently the only way I can find is do query first
and then update or insert.
Or alternatively, UPDATE and see if you've affected any rows. If not,
insert.
Michael Glaesemann
grzm seespotcode net
Thanks for your quick reply!
Is the update and insert method quick?
I have tried the query and update/insert way, and it was very slow when more
than 1 million records have been inserted. (I have more than 20 million
records to insert.)
Thanks again!
Xiao Jianfeng
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
