[postgis-users] Moving to SpatiaLite: best practice

[Paragon Corporation]

Oops slight correction.  Forget my comment about pgsql2shp.  I just realized
what I was thinking doesn't work, so you may have to dump the geometry
tables to shp and then load into SpatiaLite with the numerous loaders out
there.
 
I suppose you can chain them like pgsql2shp | shp2pgsql -w but haven't tried
that.
It would be nice if OGR2OGR supports this.  I assume that is in the works,
but I think it only supports SQLite not SpatiaLite yet.
 
Leo

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paragon
Corporation
Sent: Saturday, June 13, 2009 10:22 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Moving to SpatiaLite: best practice


Jose,