[postgis-users] dump a database with postgis 1.5 to a database with postgis 2.0
Pedro Costa
pedrocostaarma at sapo.pt
Thu Mar 14 05:52:15 PDT 2013
Hi guys,
I have one databse with postgis 1.5 and want make a dump of them to
restore in database with postgis 2.0.
I'm tried but in new database with version 2.0 i got problems.
For example, the same query [1] in postgis 1.5 give me ~500 records but
in postgis 2.0 give 0 records.
Can someone help me with that?
Thanks
[1]
select count(*)
from streets
where the_geom && GeomFromText
('POLYGON((88386.2413216648 122184.527972102,88386.2413216648
124022.075913784,91216.2575858403 124022.075913784,91216.2575858403
122184.527972102,88386.2413216648 122184.527972102))',27492);
More information about the postgis-users
mailing list