[postgis-users] how storage geometry in WKT format

[Nicolas Ribot]

> Hallo,
> I want storage geometry in WKT format. Is this possible?
>
> I tryed UPDATE lesy SET the_geom_wkt=AsText(the_geom), but my geometry is still saved in WKB format ... .
>
>

Geometries are stored internally in the postgis internal format,
neither WKB nor WKT, but a custom binary format (list, correct me if
I'm wrong).
If you want to express your geometries as a textual representation,
you can use asText(geom) when retrieving geometries.
If you still want a column holding a textual representation, create a
new column of type text and add a trigger updating this column with
the textual representation of your geometric column for each insert
(but I can't see a reason to do so).

Nicolas