Table "public.adressen_ch"
Column | Type |Modifiers
-----------+-----------------------+-----------
gid | integer |not null
strasse | character varying(80) |
hnr | character varying(80) |
adrzusatz | character varying(80) |
plz | integer |
ort | character varying(80) |
herkunft | character varying(80) |
the\_geom | geometry |
Indexes:
"adressen_ch_pkey" PRIMARY KEY, btree (gid)
"adress_idx" btree (strasse, hnr, ort) Check constraints:
"enforce_dims_the_geom" CHECK (ndims(the_geom) = 2)
"enforce_geotype_the_geom" CHECK (geometrytype (the_geom) = \ 'POINT'::text OR the_geom IS NULL)
"enforce_srid_the_geom" CHECK (srid(the_geom) = 4326)