[Qgis-user] viewing PostGIS GEOGRAPHY data

[Puneet Kishor]

I am trying to deal with data crossing the date line. I have kept a file on my Dropbox/Public folder [http://dl.dropbox.com/u/3526821/PA.gmt] which has a series of lat/lng pairs, one per line, making a single polygon. If I insert them into PostGIS as GEOMETRY, the resulting polygon is messed up. If I insert them as GEOGRAPHY, I can't view the polygon in Quantum GIS.

Any suggestion on how can I view it in QGIS? I am using QGIS 1.7 on a Mac, and Pg/Pgis 9.0.4/1.53.

Puneet.