X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 464723A5672 for ; Mon, 10 Jan 2005 17:44:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13465-10 for ; Mon, 10 Jan 2005 17:44:32 +0000 (GMT) Received: from hotmail.com (bay16-f19.bay16.hotmail.com [65.54.186.69]) by svr1.postgresql.org (Postfix) with ESMTP id DD2673A5508 for ; Mon, 10 Jan 2005 17:44:32 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 10 Jan 2005 09:44:03 -0800 Message-ID: Received: from 137.75.58.66 by by16fd.bay16.hotmail.msn.com with HTTP; Mon, 10 Jan 2005 17:43:03 GMT X-Originating-IP: [137.75.58.66] X-Originating-Email: [mytofi@hotmail.com] X-Sender: mytofi@hotmail.com From: "none none" To: pgsql-sql@postgresql.org Subject: TEXT type blob extraction in ecpg Date: Mon, 10 Jan 2005 12:43:03 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 10 Jan 2005 17:44:03.0888 (UTC) FILETIME=[F9C67300:01C4F73B] X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200501/106 X-Sequence-Number: 19894 Does any one know how to properly extract a TEXT type blob (undefined char length) in ecpg (Linux system)? We are converting our SQL from Informix to PostGres. Informix had a specific struct defined and I believe handled the dynamic memory allocation, but I cannot find any guidance on this issue for PostGres. Anyone have any suggestions? Thanks, Tom