Writes the contents of table
tableName to a shapefile
The default value of
Shapefiles do not support arbitrary geometrical data.
They do not support:
POLYGONs (they are automatically converted to
MULTIPOLYGONs when exported)
- Multiple Geometry types in the same table
Export the .prj file
If you want to export your shapefile with it’s projection, stored in a .prj file, you must assume that the table contains a SRID constraint value greater than 0.
If not the SRID must be enforced using the following commands:
mytable is the table name to update
the_geom is the geometric field name
EPSG_CODE is the EPSG id corresponding to your system (e.g
2154 for the french
Then export your shapefile as seen before.