Re: storing binary data

use bytea. search archives.

On Tue, 13 Nov 2001, Michael Lam wrote:

> I've seen people converting binary data into base64 or uuencode first before
> storing into text files. Maybe you can do the same and store in a varchar
> field if you like too? Hm...
>
> -----Original Message-----
> From: Cristovao Dalla Costa [mailto:cbraga(at)bsi(dot)com(dot)br]
> Sent: Tuesday, November 13, 2001 6:10 PM
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: [INTERFACES] 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>

--
--
Alex Pilosov | http://www.acedsl.com/home.html
CTO - Acecape, Inc. | AceDSL:The best ADSL in the world
325 W 38 St. Suite 1005 | (Stealth Marketing Works! :)
New York, NY 10018 |