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

[Mario Servin]

Thanks Stephen! now I can see them!!. How can I change the default behavior
for seeing as simple text ?

On 1/20/06, Stephen Woodbridge <woodbri at swoodbridge.com> wrote:
>
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060120/4c5e4dad/attachment.html>