[postgis-users] Moving geometry from MySQL to PostGIS

[Charles Galpin]

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>