Udnyt kvalitetssikring med constraints

CREATE TABLE place (
    id serial,
    name text,
    zipcode numeric CHECK (char_length(zipcode) = 4),
    geom geometry(Polygon, 25832) CHECK (ST_IsValid(geom))
);
--eller

ALTER TABLE place
  ADD CONSTRAINT geometry_valid_check
    CHECK (ST_IsValid(geom));

ALTER TABLE place
 ADD CONSTRAINT zipchk
  CHECK (char_length(zipcode) = 4);