Re: Handling Blobs with libpq

I'd be appreciative if someone could give or point me to a working example of storing/retrieving images via bytea.

--
thanks,
reid


-----Original Message-----
From: Doug McNaught [mailto:doug@mcnaught.org]
Sent: Thursday, March 20, 2003 11:50 AM
To: Stéphane Pinel
Cc: PostgreSQL-general
Subject: Re: [GENERAL] Handling Blobs with libpq


Stéphane Pinel <spinel@noos.fr> writes:

> What is the best approach to handle blobs with libpq ?
>
> I've read in documentation that there are 2 ways:
>
> 1- Bytea
> 2- Larges objects (lo_import)
>
> My main need is storing pictures (like Jpegs etc) or small blobs. Doc
> says that (2) is more appropriate but I need to work with blobs in
> memory, not from files.

You don't have to use lo_import()--you can write from memory to a large object using lo_write(), and read an LO (or
partof one) into memory using lo_read().  See the documentation. 

-Doug

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to
majordomo@postgresql.orgso that your message can get through to the mailing list cleanly