[postgis-users] Data representation for geometries in PostGIS

Nicolas Ribot nicky666 at gmail.com
Fri Sep 21 01:24:13 PDT 2007


> the OGC standard defines two geometry representations of spatial objects:
> WKB and WKT. Is it possible to define, in which of these formats the spatial
> objects are persisted in PostGIS or does PostGIS store them only in WKB
> format?
>
Hello

Postgis uses its own canonical format to store geometries internally:
EWKB (Extended WKB) containing geometry SRID.
You can always call astext(geom) or asbinary(geom) to get geometries
into WKT or WKB format.

HTH
Nicolas



More information about the postgis-users mailing list