Postgres Pro
Downloads
Home   >   mailing lists

Re: Lob Streaming - Mailing list pgsql-odbc

From Richard Broersma
Subject Re: Lob Streaming
Date
Msg-id AANLkTi=_BaF7=-ZhSK_GaNW3=_10fKW365GPia80d4pL@mail.gmail.com
Whole thread Raw
In response to Lob Streaming  (Ramesh Reddy <rareddy@redhat.com>)
Responses Re: Lob Streaming  (Ramesh Reddy <rareddy@redhat.com>)
List pgsql-odbc
Tree view


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

also see:
http://www.postgresql.org/docs/9.0/interactive/vacuumlo.html

--
Regards,
Richard Broersma Jr.

pgsql-odbc by date:

Previous
From: Ramesh Reddy
Date:
Subject: Lob Streaming
Next
From: Ramesh Reddy
Date:
Subject: How to turn on debugging