create table aziende_pre (gid int4 , COD_PRE varchar , NOME_PRE varchar , NOME_PRE0 float8 );
ALTER TABLE aziende_pre ADD COLUMN the_geom geometry;
ALTER TABLE aziende_pre ALTER COLUMN the_geom SET STORAGE MAIN;
ALTER TABLE aziende_pre ADD CONSTRAINT aziende_pre_pkey PRIMARY KEY(gid);
ALTER TABLE aziende_pre ADD CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
ALTER TABLE aziende_pre ADD CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL);
ALTER TABLE aziende_pre ADD CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = -1);

insert into aziende_pre values ('0','198','NOME COGNOME','171.0',GeometryFromText('MULTIPOLYGON (( (-16266.6710 -35891.0000 , -16274.8810 -35898.3500 , -16275.7530 -35899.1270 , -16280.1430 -35903.5010 , -16282.2910 -35905.6410 , -16283.7400 -35907.1820 , -16300.0900 -35924.1600 , -16301.2810 -35925.8700 , -16269.0710 -35950.6500 , -16254.7110 -35962.5300 , -16248.8110 -35966.8000 , -16245.3110 -35971.3300 , -16236.7600 -35949.0300 , -16229.9300 -35932.7000 , -16228.7300 -35930.6500 , -16228.4110 -35929.7900 , -16245.3910 -35911.7700 , -16248.2110 -35908.9500 , -16249.0710 -35908.5200 , -16266.6710 -35891.0000)))',-1) );