> Is this normal or are there something else I could do so I don't have > to check if it exists?
I would say that it is normal. > For the developers: a combined insert/update command would be nice > :-) Mysql has such a beast along a some other non SQL compliant extensions. One possible approach to what you are trying to do would be: update existing table with new values delete from new table all records that already exist insert remaining new records Which can be done all in pure sql. No need to write a program. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
