Re: Copy data from one table to another, where some records might

Otto Blomqvist wrote:

> Hello !
>
> I have two tables with identical schema. I want to copy all data from
> Table A to Table B, but table B might already have some of table A:s
> data (each record is identified using record_numbers). I would suspect
> this can be accomlished using a 2 stage query, first performing a join
> of some kind and then the copying. But I have little to no clue on how
> to make it happen.
>
> Any ideas ?

This shall help you:

regression=# create table A ( fa1 integer, fa2 integer );
CREATE TABLE
regression=# create table B ( fb1 integer, fb2 integer );
CREATE TABLE
regression=# insert into B
regression-# select fa1, fa2 from A
regression-# where (fa1, fa2) not in (
regression(# select fa1, fa2 from B );
INSERT 0 0

Regards
Gaetano Mendola