Thread: storing binary data

Hi,

I'm using libpq to interface my program to postgresql, and I need to store
some binary data (around 30-40 bytes per element). I'm not sure of the best
way to do so, since blobs seem awkward. How would you do it? How would you
insert it in a text field?

Thanks all,

Cristovao

For the folks who already read the email below in -INTERFACES, I'm sorry it
got to this list a couple days late. I'm using BYTEA now, and thanks again.

Cristovao

----- Original Message -----
From: "Cristóvão Dalla Costa" <cdallacosta@bigfoot.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, November 13, 2001 6:30 PM
Subject: [GENERAL] storing binary data


> Hi,
>
> I'm using libpq to interface my program to postgresql, and I need to store
> some binary data (around 30-40 bytes per element). I'm not sure of the
best
> way to do so, since blobs seem awkward. How would you do it? How would you
> insert it in a text field?
>
> Thanks all,
>
> Cristovao