This is an old revision of the document!
world=# create table membership_raw (State text, GNI text, wage text, UN text, CoE text, OSCE text, EU text, EEA text, CU text, Schengen text, euro text, OECD text, WTO text, ESA text, NATO text, ICC text, VWP text); world=# \encoding latin1 world=# copy membership_raw from '/home/mh/world/europa.csv' delimiter ';'; world=# select count(code2) from countries where name in (select state from membership_raw); count ------- 44 (1 row) es stimmen also 7 Ländernamen nicht überein world=# select count(state) from membership_raw where state not in (select name from countries); count ------- 7 (1 row) world=# select state from membership_raw where state not in (select name from countries); state ------------------ Bosnia and Herz. Kazakhstan Kosovo Montenegro Russia Serbia Vatican City (7 rows)