postgres sql insert into

Question

postgres sql insert into

Navigation

#1 by (1 votes)
#2 by (0 votes)

0

I have to copy data from two databases to a new one, it happens that when you copied new data these already exist but there are new ones that are not inserted.

The query I have at the moment is this:

INSERT INTO concelho(id,censo,concelho)
SELECT "CONCELHO","CENSO","CONCELHO_DSG"
FROM dblink('dbname=meu_db host=meu_host user=meu_user password=minha_senha' ::text,'SELECT "CONCELHO","CENSO","CONCELHO_DSG" FROM "MUNICIPIO (Concelho)"' ::text,false) 
as tabela_temp("CONCELHO" varchar, "CENSO" varchar, "CONCELHO_DSG" character varying (200))

postgresql

asked by anonymous 01.01.2016 / 17:13

2 answers

How to make the code write information from multiple files? Manipulate one item at a time in the API

score 1 · Answer 1

Already resolved

'INSERT INTO concelho(id,censo,concelho)´SELECT "CONCELHO","CENSO","CONCELHO_DSG"FROM dblink('dbname=meu_db host=meu_hostuser=meu_user password=minha_senha'::text,'SELECT"CONCELHO","CENSO","CONCELHO_DSG" FROM"MUNICIPIO (Concelho)"' ::text,false) as tabela_temp("CONCELHO" varchar,"CENSO" varchar, "CONCELHO_DSG" character varying (200))WHERE    NOT EXISTS (SELECT id,censo,concelho FROM concelho WHERE id = tabela_temp."CONCELHO" 
);'

score 0 · Answer 2

insert into concelho(id,censo,concelho)
select "CONCELHO","CENSO","CONCELHO_DSG"
from dblink(
    'dbname=meu_db host=meu_host user=meu_user password=minha_senha' ::text,
    'SELECT "CONCELHO","CENSO","CONCELHO_DSG" FROM "MUNICIPIO (Concelho)"' ::text,false)
as tabela_temp("CONCELHO" varchar, "CENSO" varchar, "CONCELHO_DSG" character varying (200))
except
select "CONCELHO","CENSO","CONCELHO_DSG"
from concelho