Skip to content

Instantly share code, notes, and snippets.

View countries-postgresql.sql
CREATE TABLE country (
id int NOT NULL PRIMARY KEY,
iso varchar NOT NULL,
name varchar NOT NULL,
nicename varchar NOT NULL,
iso3 varchar DEFAULT NULL,
numcode smallint DEFAULT NULL,
phonecode int NOT NULL
);