[postgis-users] coordinate axes swap

[Vojtech Honzik]

I have simple 2D dataset in spatial reference system SRID=-1 (should be
Krovak - SRID=102067, after correction)
Somebody who created the data simply swapped x and y coordinate so it does
not fit to any of available projections. Is there some simple way in PostGIS
how to switch both x and y coordinates for all points in all features? Or
will I have to dump the data out from the database and write some script
switching the coordinates in the sql dump?

Thank you,
Vojtech Honzik

-------------------
Vojtech Honzik
Dpt. of Mapping and Cartography
Civil Eng. Faculty, CTU Prague
tel.: +420 777 136 711
e-mail: v.honzik at sh.cvut.cz
----------------