On Mon, Feb 7, 2011 at 7:00 AM, Ramesh Reddy <rareddy(at)redhat(dot)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.