how to read bytea column from dblink

From: "Aynur SANCAKLI" <aynur(dot)sancakli(at)kamusm(dot)gov(dot)tr>
To: pgsql-admin(at)postgresql(dot)org
Subject: how to read bytea column from dblink
Date: 2008-09-16 06:46:40
Message-ID: df66142d728e0a2bd915c1902977d940.squirrel@mail.kamusm.gov.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi,
I try to read bytea column from postgresql db over a dblink in Oracle DB.
But I could not. How can I solve the problem?
In windows environment there is a parameter in odbc driver bytea as LO. I
could not find how to set it on unix odbc.

Versions of products I Use:

Postgresql 8.3.3 on redhat
Oracle DB : 10.2.0.4 on HP/UX
HSODBC : 10.2.0.4

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mauri Sahlberg 2008-09-16 08:31:47 Help request: how to tune performance?
Previous Message hanumantha reddy 2008-09-16 04:53:22 connecting to server