Insert records

jas2803

I have two tables, the first table has 2000+ records the other only has approx 500....two columns as "linked" that is they are the same information.....PK and date...I would like to insert the remaining 1500+ records into the smaller table.

what I need is an if not exist in table2 insert new record using table1 values PK, date

Any Ideas?

rski

a- biger table (i is primary key column)
b -smaller table (m is primary key column)

Expand|Select|Wrap|Line Numbers

 
insert into b select * from a where not exists (select * from b where b.m=a.i);

Is it ok?

jas2803

That was just what I needed, thanks very much!!!!!

Insert records

re: Insert records

re: Insert records

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about