Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group