Handling Blobs with libpq

From: Stéphane Pinel <spinel(at)noos(dot)fr>
To: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Handling Blobs with libpq
Date: 2003-03-20 11:11:20
Message-ID: ADF671C5-5AC4-11D7-8432-000A27AFF5D2@noos.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
------------------------------------------------------------------------
---

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Olleg Samojlov 2003-03-20 11:34:31 Re: About tcp connection
Previous Message Martin Foster 2003-03-20 10:18:26 Case sensitivity and migration