CcV8Ssdg

1\set path '''' `pwd`/NNPC_fixed.csv ''''
2
3CREATE EXTENSION IF NOT EXISTS prefix WITH SCHEMA public;
4
5DROP TABLE IF EXISTS national_destination_codes;
6
7CREATE TABLE national_destination_codes (
8    id SERIAL,
9    country character varying(255),
10    iso3166_3 character varying(3),
11    iso3166_2 character varying(2),
12    idd character varying(255),
13    cc character varying(255),
14    ndc1 character varying(255),
15    ndc1t character varying(255),
16    ndc2 character varying(255),
17    sn1 character varying(255),
18    sn1t character varying(255),
19    sn2 character varying(255),
20    snl character varying(255),
21    description character varying(255),
22    number_type character varying(255),
23    test_numbers character varying(255),
24    start_date timestamp without time zone,
25    end_date timestamp without time zone,
26    last_update timestamp without time zone,
27    net_name character varying(255),
28    net_type character varying(255),
29    mcc character varying(255),
30    mnc character varying(255),
31    tadig_nc character varying(255),
32    handset_code character varying(255),
33    net_start_date timestamp without time zone,
34    net_end_date timestamp without time zone,
35    operator character varying(255),
36    licensed_service_area character varying(255),
37    country_notes text,
38    nop_notes text,
39    net_notes text,
40    prefix_notes text,
41    row_insertion_date timestamp without time zone,
42    prefix prefix_range
43);
44
45COPY national_destination_codes (country, iso3166_3, iso3166_2, idd, cc, ndc1, ndc1t, ndc2, sn1, sn1t, sn2, snl, description, number_type, test_numbers, start_date, end_date, last_update, net_name, net_type, mcc, mnc, tadig_nc, handset_code, net_start_date, net_end_date, operator, licensed_service_area, country_notes, nop_notes, net_notes, prefix_notes, row_insertion_date)
46FROM :path DELIMITER '|' CSV HEADER ENCODING 'windows-1251';
47
48CREATE INDEX idx_prefix ON national_destination_codes USING gist(prefix);
49
50UPDATE national_destination_codes SET prefix = CONCAT(cc, ndc2, sn2);