when I'm trying to use shp2pgsql to convert a shp file into postgresql. as I do it using the following commands: 1, shp2pgsql pt_gsqy_point.shp pt_gsqy_point postgis> pt_gsqy_point.sql 2, psql -d postgis -f pt_gsqy_point.sql >log.txt
after I run *the first command*, and I got sql script file: the content is : BEGIN; CREATE TABLE "pt_gsqy_point" (gid serial PRIMARY KEY, "name" varchar(40)); SELECT AddGeometryColumn('','pt_gsqy_point','the_geom','-1','POINT',2); INSERT INTO "pt_gsqy_point" ("name",the_geom) VALUES ('the first location name','010100000085EC6F9141E2C5C0E829EE9F0AC98240'); INSERT INTO "pt_gsqy_point" ("name",the_geom) VALUES ('the second location name','0101000000CCFE346E05B4C5C0A9A946F9A30D8640'); ..... ... etc... and after *I run the second command*, in the pgadmin, I got to see the values in it. but the geometry values can not be used directly, as the values are those : '010100000085EC6F9141E2C5C0E829EE9F0AC98240', anyone in the mailist have used the shp2pgsql.exe??? how to deal with it, so that I can use those point coordinates to do some operations, such as select a point using the point coordinate to get the name of it. thankyou. yours, shieldy
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users