Countries

Explore how to identify and fix normalization issues in country data using PostgreSQL. Learn to create associations between countries and their neighbors to enable efficient geographic queries in your database.

We'll cover the following...

Normalization failures
Checking for dependencies
Normalization process
Neighbor countries
Try it yourself

The raw.country table has several normalization issues. Before we list them, take a look at some data below:

─[ RECORD 1 ]──────┬─────────────────────────
iso                │ FR
iso3               │ FRA
isocode            │ 250
fips               │ FR
name               │ France
capital            │ Paris
area               │ 547030
population         │ 64768389
continent          │ EU
tld                │ .fr
currency_code      │ EUR
currency_name      │ Euro
phone              │ 33
postal_code_format │ #####
postal_code_regex  │ ^(\d{5})$
languages          │ fr-FR,frp,br,co,ca,eu,oc
geonameid          │ 3017382
neighbours         │ CH,DE,BE,LU,IT,AD,MC,ES
fips_equiv         │ ¤

...