Postgres Dialect | dr5hn / countries-states-cities-database

create-and-insert-countries.sql

CREATE TABLE countries (
   id integer  NOT NULL,
   name varchar(100) NOT NULL,
   iso3 char(3) DEFAULT NULL,
   numeric_code char(3) DEFAULT NULL,
   iso2 char(2) DEFAULT NULL,
   phonecode varchar(255) DEFAULT NULL,
   capital varchar(255) DEFAULT NULL,
   currency varchar(255) DEFAULT NULL,
   currency_name varchar(255) DEFAULT NULL,
   currency_symbol varchar(255) DEFAULT NULL,
   tld varchar(255) DEFAULT NULL,
   native varchar(255) DEFAULT NULL,
   region varchar(255) DEFAULT NULL,
   subregion varchar(255) DEFAULT NULL,
   timezones text,
   translations text,
   latitude decimal(10,8) DEFAULT NULL,
   longitude decimal(11,8) DEFAULT NULL,
   emoji varchar(191) DEFAULT NULL,
   emojiU varchar(191) DEFAULT NULL,
   created_at timestamp NULL DEFAULT NULL,
   updated_at timestamp NOT NULL DEFAULT NULL,
   flag smallint NOT NULL DEFAULT '1',
   wikiDataId varchar(255) DEFAULT NULL,
   PRIMARY KEY (id)
);

CREATE SEQUENCE countries_id_seq;
ALTER TABLE countries
    ALTER id
        SET DEFAULT NEXTVAL('countries_id_seq');