Create schema and table

Text

DROP SCHEMA IF EXISTS gazetteer CASCADE;
COMMIT;
CREATE SCHEMA gazetteer;
COMMIT;

CREATE TABLE gazetteer.gazetteer (
ogc_fid integer NOT NULL PRIMARY KEY,
km_ref varchar,
def_nam varchar,
tile_ref varchar,
lat_deg numeric,
lat_min numeric,
long_deg numeric,
long_min numeric,
north numeric,
east numeric,
gmt varchar,
co_code varchar,
county varchar,
full_county varchar,
f_code varchar,
e_date date,
update_co varchar,
sheet_1 numeric,
sheet_2 numeric,
sheet_3 numeric);
COMMIT;