I have uploaded few shape files to posgres by using shp2pgsql followed by psql commands. Data was loaded to the database without any problems. However when I try to view the geometry column of some of the loaded files by using PgAdmin III edit data display I see blank geometry columns, and executing the command like "select IsEmpty(the_geom) from provinces" confirms that the field content is not empty. I cant understand why the values are not displayed in the PgAdmin III edit data display.
Postgres version info "PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" -- Damitha D. Karunaratna (PhD) University of Colombo School of Computing, Universitry of Colombo 35, Reid Avenue, Colombo 7, Sri Lanka. Telephone : +94-11-2591063 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs