[postgis-devel] shp2pgsql using problem

zhengyong zhang shieldly at gmail.com
Mon Jun 30 01:05:10 PDT 2008


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 > 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.


-- 
Zhengyong Zhang
ECNU CS
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20080630/cf8997ac/attachment.html>


More information about the postgis-devel mailing list