Re: binary format of array stored as text

On Wed, Sep 2, 2009 at 3:50 PM, Dave
Huber<DHuber@letourneautechnologies.com> wrote:
> I have an old table with a column specified as integer[]. The data within
> this column was stored as text ala {1,2,3,…} yada yada. I have an
> application where I am reading all the columns from a row in this table in
> binary format. Does anybody know how I can recast/reshape this binary data
> back into an array of integers?

check out our libpqtypes library:
http://libpqtypes.esilo.com/

It pulls all data as binary and allows you to access array elements,
and you can write data the same way.  PostgreSQL binary formats are
more complicated than you think: there is dimension information, etc.
in there.  (that said, sending int[] as binary is much faster).

merlin