In SQLite or MySQL there is a statement INSERT OR REPLACE , is something like this in postgres , or could be ?
No, there isn't and there currently isn't anyone working on adding it.
Chris
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match