Postgres Pro
Downloads
Home   >   mailing lists

Handling Blobs with libpq - Mailing list pgsql-interfaces

From Stéphane Pinel
Subject Handling Blobs with libpq
Date
Msg-id 41AAAA03-5ABA-11D7-8432-000A27AFF5D2@noos.fr
Whole thread Raw
Responses Re: Handling Blobs with libpq  ("Jeroen T. Vermeulen" <jtv@xs4all.nl>)
Re: Handling Blobs with libpq  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Re: Handling Blobs with libpq  (Daniel Bruce Lynes <dlynes@shaw.ca>)
List pgsql-interfaces
Tree view 
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.

Thanks for your help.

------------------------------------------------------------------------ 
---
Stephane
------------------------------------------------------------------------ 
---

pgsql-interfaces by date:

Previous
From: Philip Yarra
Date:
Subject: Re: [BUGS] Bug #904: Deallocating of prepared statement in ECPG at
Next
From: Gerhard Häring
Date:
Subject: I want to send comments to the backend!