Emilio, That is the default storage now, binary. If you want the text representation, select AsTExt(calles_geom);
Robert W. Burgholzer Surface Water Modeler Office of Water Supply and Planning Virginia Department of Environmental Quality [EMAIL PROTECTED] 804-698-4405 Open Source Modeling Tools: http://sourceforge.net/projects/npsource/ Web-Based Water Supply Planning Demo: http://soulswimmer.dynalias.net/models/wsdemo/demo_hsi.php -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emilio Ponce Sent: Monday, October 22, 2007 12:10 PM To: postgis-users@postgis.refractions.net Subject: [postgis-users] Problem with geodata storage Hi everyone, here Emilio from Barcelona, I've found a problem with my postgresql+postgis under ubuntu. When I tried to store a geometry worked well, but when I tried to get this data with a select I found this strange numbers: testgis=# select * from calles_geom; id | name | geom ----+---------+--------------------------------------------------------- --------------------------- 1 | Jeff Rd | 01020000000200000000000000005807410000000070AD0D410000000020540741000000 0050B10D41 (1 fila) I've done this to store the data: CREATE TABLE CALLES_GEOM( ID int4, NAME varchar(25) ); SELECT AddGeometryColumn('calles_db','calles_geom','geom','-1', 'LINESTRING',2); BEGIN; INSERT INTO CALLES_GEOM(ID,GEOM,NAME) VALUES (1, GeometryFromText('LINESTRING(191232 243118,191108 243242)',-1),'Jeff Rd'); END; Then,anyone know why the geom column is not 'LINESTRING(191232 243118,191108 243242)'? Thanks! -- Emilio _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
