PLEASE MAKE SURE YOU BACKUP YOUR PUBLIC SCHEMA ! Steps: Open up pgAdmin III and connect to PostgreSQL. Select desired database and click on schemas
read morePlease check geometry_columns table if the result return `-1`. You may change the srid value if you knew the value of the target table. Value
read moreST_AsText – represent geometry as WKT ST_Transform – transform geometry from one projection to another ST_GeomFromText – represent WKT as geometry Reference: PostGIS 1.5 Manual
read moreJust a note, do run ‘legacy.sql‘ when migrate from PostGIS 1.5 to PostGIS 2.0 because there’s functions being removed from 1.5. so we need it
read moreA good tutorial on WFS-T. Didn’t try it yet, but will try it soon. http://www.gistutor.com/openlayers/22-advanced-openlayers-tutorials/47-openlayers-wfs-t-using-a-geoserver-hosted-postgis-layer.html
read more