[postgis-users] Help dumping data from an old database

p valdes p.valdes334 at gmail.com
Mon Aug 22 03:44:33 PDT 2011


maybe you could first reduce the problem

create a view of all fields of your table except the geom columns

try to pg_dump it, this don't need postgis so could go

create a second view of the geom columns specifying AsText(geom) and a
field reference

copy this view to a text file with \g option

join together all



More information about the postgis-users mailing list