Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

public.iso3166

Description

This is a complete list of all country ISO codes as described in the ISO 3166 international standard. Country Codes Alpha-2 & Alpha-3 https://www.iban.com/country-codes

Columns

NameTypeDefaultNullable
alpha_2texttrue
alpha_3texttrue
countrytexttrue
idintegerfalse

Constraints

NameTypeDefinition
iso3166_id_not_nullnNOT NULL id
iso3166_pkeyPRIMARY KEYPRIMARY KEY (id)

Indexes

NameDefinition
iso3166_pkeyCREATE UNIQUE INDEX iso3166_pkey ON public.iso3166 USING btree (id)

Relations

erDiagram


"public.iso3166" {
  text alpha_2 ""
  text alpha_3 ""
  text country ""
  integer id ""
}

Generated by tbls