lib-sql/postcode_tables.sql

   1 DROP TABLE IF EXISTS gb_postcode;
   2 CREATE TABLE gb_postcode (
   3     id integer,
   4     postcode character varying(9),
   5     geometry geometry,
   6     CONSTRAINT enforce_dims_geometry CHECK ((st_ndims(geometry) = 2)),
   7     CONSTRAINT enforce_srid_geometry CHECK ((st_srid(geometry) = 4326))
   8 );
   9
  10 DROP TABLE IF EXISTS us_postcode;
  11 CREATE TABLE us_postcode (
  12     postcode text,
  13     x double precision,
  14     y double precision
  15 );