[postgis-users] Moving geometry from MySQL to PostGIS

Charles Galpin cgalpin at lhsw.com
Tue Aug 30 06:58:33 PDT 2011

On Aug 29, 2011, at 2:29 PM, Mr. Puneet Kishor wrote:
> the data themselves are routine points, lines and polygons (MySQL allows defining POINT, LINE, POLYGON, or the all-encompassing GEOMETRY). Other than that, there are the usual MySQL->Pg mismatches such as `mediumint` and `enum`. I tried 
> `mysqldump --compatible=postgresql` but that doesn't go far enough. Hand editing of the export file seems to be required.

How about generating insert statements compatible with postgresql, using wkt as the common format that you can then run on postgresql? 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110830/dd9e2947/attachment.html>

More information about the postgis-users mailing list