35 lines
1.1 KiB
Plaintext
35 lines
1.1 KiB
Plaintext
insert into rpu
|
|
(tip, skupina, podskupina, sifra_pu, maticna, davcna, ustanovitelj, naziv, kraj, obcina, skd, a, b, c, d, e, f, g, h, i, j, naslov, postna_stevilka, posta, ezr, sifra_proracuna, zadnjasprememba, email)
|
|
select
|
|
tip, skupina, podskupina, sifra_pu, maticna, davcna, ustanovitelj, naziv, kraj, obcina, skd, a, b, c, d, e, f, g, h, i, j, naslov, postna_stevilka, posta, ezr, sifra_proracuna, '2023-10-17', email
|
|
FROM rpu_old
|
|
ON CONFLICT ("sifra_pu") DO UPDATE
|
|
SET
|
|
tip=excluded.tip,
|
|
skupina=excluded.skupina,
|
|
podskupina=excluded.podskupina,
|
|
sifra_pu=excluded.sifra_pu,
|
|
maticna=excluded.maticna,
|
|
davcna=excluded.davcna,
|
|
ustanovitelj=excluded.ustanovitelj,
|
|
naziv=excluded.naziv,
|
|
kraj=excluded.kraj,
|
|
obcina=excluded.obcina,
|
|
skd=excluded.skd,
|
|
a=excluded.a,
|
|
b=excluded.b,
|
|
c=excluded.c,
|
|
d=excluded.d,
|
|
e=excluded.e,
|
|
f=excluded.f,
|
|
g=excluded.g,
|
|
h=excluded.h,
|
|
i=excluded.i,
|
|
j=excluded.j,
|
|
naslov=excluded.naslov,
|
|
postna_stevilka=excluded.postna_stevilka,
|
|
posta=excluded.posta,
|
|
ezr=excluded.ezr,
|
|
sifra_proracuna=excluded.sifra_proracuna,
|
|
zadnjasprememba='2023-10-17',
|
|
email=excluded.email; |