Hi Zhang,
There is no problem.
This is the ewkb format used by postgis in order to storing geo data.
Use the astext() function if you want to see you data in human
readable format (wkt)
select astext(the_geom) from pt_gsqy_point;
it should be good! :)
Quoting zhengyong zhang <[EMAIL PROTECTED]>:
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
===================
Jean David TECHER
06 60 46 85 05
04 99 77 17 87
===================
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
