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

From Bret Stern
Subject Re: Using ODBC and VBA to pull data from a large object
Date
Msg-id 1379426774.2677.0.camel@centos-dev.machinemanagement.com
Whole thread Raw
In response to Using ODBC and VBA to pull data from a large object  (Adam C Falkenberg <ACFalkenberg@uss.com>)
Responses Re: Using ODBC and VBA to pull data from a large object  (Adam C Falkenberg <ACFalkenberg@uss.com>)
List pgsql-general
On Tue, 2013-09-17 at 08:32 -0400, Adam C Falkenberg wrote:
> 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


Microsofts sample
http://support.microsoft.com/kb/258038



pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: need a hand with my backup strategy please...
Next
From: karinos57
Date:
Subject: Re: using Replace funcion in postgresql