Re: storing binary data

From: Michael Lam <mlam(at)rim(dot)net>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: storing binary data
Date: 2001-11-13 23:31:39
Message-ID: C5F1D2493CDBD14F83AD2DCA9DB882ED1371E8@xch05ykf.rim.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Alex Pilosov 2001-11-14 00:08:49 Re: storing binary data
Previous Message Cristóvão Dalla Costa 2001-11-13 23:10:06 storing binary data