[postgis-users] reading postgis objects

[Mark Cave-Ayland]

On Mon, 2007-09-10 at 16:09 +0200, Malm Paul wrote:
> 
> Hi, I have not found any description of the binary format of polygons,
> points etc.. is there any?
> 
> I would like to select objects of an Postgis feature type an save them
> into a propiatary graphic format. 
> I can do it with: Select astext... 
> But I imagine that it will be faster to get the selection set in a
> binaryformat, or?
> 
> Kind regards,  
> 
> Paul Malm

Do a "SELECT AsBinary(the_geom) FROM geom_table". AsBinary() returns the
OGC-standard Well Known Binary (WKB) format. See the OGC website to
download the standards documents for the WKB format and much more.


ATB,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk