Le query eseguite:
CREATE TABLE province_simpl1 AS
SELECT id, provincia,
ST_Simplify(geom,500)::GEOMETRY(MultiPolygon,3003)
AS geom
FROM province;
CREATE TABLE province_simpl_topo AS
SELECT id, provincia,
ST_SimplifyPreserveTopology(geom,500)::GEOMETRY(Polygon,3003)
AS geom
FROM province;
link per approfondire: https://trac.osgeo.org/postgis/wiki/U...