Re: Lob Streaming

On Mon, Feb 7, 2011 at 7:00 AM, Ramesh Reddy <rareddy@redhat.com> wrote:

Hi,

Does psql-odbc driver support lob streaming? I could successfully get
'bytea' content, but for large size > GB lobs I  am running into memory
issues. Can you body suggest any alternatives.

Try using the PostgreSQL contrib module "lo."

http://www.postgresql.org/docs/9.0/interactive/lo.html