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