[postgis-users] Best way to return a WKB when using pglib

[mateusz at loskot.net]

I also use

encode(asbinary(the_geom), 'hex')

which is about 30% bigger in volume but simple and fast in parsing.

Mateusz

Paul Ramsey wrote:
> encode(asbinary(the_geom), 'base64')
> 
> Rob Tester wrote:
>> I am writing an extension (libpg) that ultimately can create several 
>> hundred to several thousand WKT polygons. Once I have the WKT created, 
>> instead of returning them I would prefer to return the WKB inside the 
>> tuple. How can I efficiently return a WKB inside the tuple instead of 
>> the WKT?
>>  
>> Any help or push in the right direction would be appreciated.
>