Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F3D719FB8EB for ; Tue, 22 May 2007 15:24:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 74451-06 for ; Tue, 22 May 2007 15:24:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp106.rog.mail.re2.yahoo.com (smtp106.rog.mail.re2.yahoo.com [68.142.225.204]) by postgresql.org (Postfix) with SMTP id C6E7D9FB5C6 for ; Tue, 22 May 2007 15:24:08 -0300 (ADT) Received: (qmail 95862 invoked from network); 22 May 2007 18:24:06 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=rogers.com; h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=BkWSpN3bDlyOXUmn/8CvyxfD91GxU+uYtndcCoqH0BGPv5wY1GAnuYfenrxJov1KCHHbP7YffepYTkx/eTqopZEJ5lW0GF+YsZmpOAZDqiqXZgNX2gQPTzxxYKzHmUQC/QNM2bNERkjC8TzXHF+FE+v1sh5oaT02/eF4+VAqVPU= ; Received: from unknown (HELO ?127.0.0.1?) (ymlam@rogers.com@216.209.33.106 with plain) by smtp106.rog.mail.re2.yahoo.com with SMTP; 22 May 2007 18:24:05 -0000 X-YMail-OSG: pEwZcjEVM1nS8n8YnxwjeJt8DRR5Ex8gdVr3wt5kB6KyrpvO_R.HwooZl_4tUx3.Aw-- Message-ID: <4653353B.4040607@rogers.com> Date: Tue, 22 May 2007 14:23:55 -0400 From: Jeff Lynn User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org, jtv@xs4all.nl Subject: Re: PQgetvalue failed to return column value for non-text data in binary format Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.184 tagged_above=0 required=5 tests=AWL=-0.984, BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708 X-Spam-Level: X-Archive-Number: 200705/43 X-Sequence-Number: 6550 Thank you for your suggestion of COPY API. I will take a look. The trouble is, I cannot seems to find any example that illustrate any non-text data usage. The PostgreSQL doc is extensive, provided you already know the details and serve well during implementation of applications. For beginner, there is no cohesive way to lead me read thru the doc in proper sequence. All tutorial and examples gave me knowledge to do very simple stuff. The extensive documentation only lead to more questions. Jeff