[postgis-users] how to transfer wkt geometry from mysql to postgis?

2012-08-09 Thread Robert Buckley 
Hi,

I have wkt geometry data in mysql stored in blob format.
I need to get this data into a postgis db and am looking for the 
quickest-easiest way to do it. I have managed to select the data ASTEXT but 
can then only copy it into QGIS - export to shape - import to postgisbut 
this is probably not the easiest way.

Is there a way to directly import a table from mysql into postgis?

thanks for any help,

Robert ___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] how to transfer wkt geometry from mysql to postgis?

2012-08-09 Thread Sandro Santilli 
On Thu, Aug 09, 2012 at 08:58:55AM +0100, Robert Buckley wrote:

 Is there a way to directly import a table from mysql into postgis?

Try ogr2ogr

--strk;

 http://www.cartodb.com - Map, analyze and build applications with your data

   ~~ http://strk.keybit.net 

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users