[postgis-users] possible to pg_dump postgis 1.0 table, restore to postgis 0.9 database?

[strk at refractions.net]

pgsql2shp/shp2pgsql seems the easiest way to me.
--strk;

On Wed, Jul 13, 2005 at 12:23:48PM -0500, Jeff Hoffmann wrote:
> What's the easiest way to copy a postgis version 1.0 table to a server 
> that only has postgis 0.9 installed?  If they were both 0.9, I could do 
> a dump/restore with pg_dump, but the dump format for geometry columns is 
> different in the new version of postgis so I can't do that.  Is the only 
> other option going through a shape file with pgsql2shp/shp2pgsql?  Or is 
> there a way to get pg_dump to dump geometry columns as WKT?
> 
> -- 
> Jeff Hoffmann
> jeff at propertykey.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users