Re: [despammed] [SQL] update/insert data

2004-11-28 Thread Kretschmer Andreas
am Sat, dem 27.11.2004, um 12:55:40 -0500 mailte Keith Worthington folgendes: > Hi All, > > I have two tables in different schemas. The first table in the data_transfer > schema is loaded with a COPY command. I need to transfer the data to the > second schema inserting new records and updating

[SQL] update/insert data

2004-11-27 Thread Keith Worthington
Hi All, I have two tables in different schemas. The first table in the data_transfer schema is loaded with a COPY command. I need to transfer the data to the second schema inserting new records and updating existing records. What is the best way to achieve this functionality? Kind Regards, Kei