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? 
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to