Using ODBC and VBA to pull data from a large object - Mailing list pgsql-general

From Adam C Falkenberg
Subject Using ODBC and VBA to pull data from a large object
Date
Msg-id OF3CF5E228.475F196A-ON85257BE9.003D11A8-85257BE9.0044E365@notes.uss.com
Whole thread Raw
Responses Re: Using ODBC and VBA to pull data from a large object  (Bret Stern <bret_stern@machinemanagement.com>)
List pgsql-general
Good Morning,

I had a question about using ODBC with large objects.  When I query the pg_largeobject table and return data to an ADO recordset, I can only get the first 255 bytes even though the record contains 2048 bytes of data (all the bytes after the first 255 show as 0).  When I checked the type of the record, it was a VarBinary.  Is there a way to have all of the data returned to the recordset?  Thanks for any help.

Adam

pgsql-general by date:

Previous
From: "Echlin, Jamie (KFIA 611)"
Date:
Subject: Re: need a hand with my backup strategy please...
Next
From: Albe Laurenz
Date:
Subject: Re: need a hand with my backup strategy please...