Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0E23C64FCC6 for ; Tue, 16 Sep 2008 03:53:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 57923-06 for ; Tue, 16 Sep 2008 03:53:26 -0300 (ADT) X-Greylist: delayed 00:06:40.73961 by SQLgrey-1.7.6 Received: from mail.kamusm.gov.tr (ns1.kamusm.gov.tr [193.140.71.10]) by postgresql.org (Postfix) with ESMTP id 70F0764FCC3 for ; Tue, 16 Sep 2008 03:53:25 -0300 (ADT) Received: (qmail 7796 invoked by uid 89); 16 Sep 2008 06:46:40 -0000 Received: by simscan 1.3.1 ppid: 7789, pid: 7790, t: 0.0960s scanners: regex: 1.3.1 attach: 1.3.1 clamav: 0.93.3/m:47 Received: from unknown (HELO mail.kamusm.gov.tr) (127.0.0.1) by mail.kamusm.gov.tr with SMTP; 16 Sep 2008 06:46:40 -0000 Received: from 10.1.7.83 (SquirrelMail authenticated user aynur.sancakli) by mail.kamusm.gov.tr with HTTP; Tue, 16 Sep 2008 09:46:40 +0300 (EEST) Message-ID: In-Reply-To: References: <200809120959.15153.barbara@turbocorp.com> <1221229441.1378.5.camel@enterprise.ims-firmen.de> Date: Tue, 16 Sep 2008 09:46:40 +0300 (EEST) Subject: how to read bytea column from dblink From: "Aynur SANCAKLI" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.15-1.3.10 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-9 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/155 X-Sequence-Number: 30248 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