[postgis-users] shp2pgsql using problems

Jean David TECHER david.techer at davidgis.fr
Tue Jul 1 00:30:42 PDT 2008

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 <shieldly at gmail.com>:

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

More information about the postgis-users mailing list