Content Comparison

create schema gadm;

CREATE TABLE gadm.gadm
(
  objectid integer NOT NULL,
  id_0 integer,
  iso character varying(5),
  name_0 character varying(50),
  id_1 integer,
  name_1 character varying(50),
  type_1 character varying(50),
  id_2 integer,
  name_2 character varying(70),
  type_2 character varying(50),
  id_3 integer,
  name_3 character varying(70),
  the_geom geometry,
  CONSTRAINT gadm7_pkey PRIMARY KEY (objectid ),
  CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),
  CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 4326)
);