[postgis-users] Upgrading from PostgreSQL 8.0 with PostGIS 0.9 to PostgreSQL 8.1 with PostGIS 1.0

[Stephen Woodbridge]

Mario Servin wrote:
> Hi everybody,
>
[snip]
 >
> Additionally, I still have the results from the old shp2pgsql and so I 
> tried to insert the data form psql using \i mysqlinsertionscript.sql. 
> Tables are created ok, but geom columns results in meaningless 
> characters where it is supossed to be something like "POINT (- 66.046532 
> -21.951437)" for example.

The default behavior changed. Try:

select aswkt(the_geom) from table;

the default is to display the geometry in a hex representation of the 
binary.

-Steve W.

> Can anybody help me?.
> Regards,
>             Mario Servin
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users