From: Sean Davis <sdavis2@mail.nih.gov>
Reply-To: sdavis2@mail.nih.gov
Organization: NIH/NCI
To: Sandeep Khandelwal <sandeep_khandelwal27@yahoo.com>
Subject: Re: Bulk Load and Extract from PostgreSQL
Date: Tue, 17 Oct 2006 08:23:14 -0400
User-Agent: KMail/1.9.1
Cc: pgsql-interfaces@postgresql.org
References: <20061017121825.72937.qmail@web33309.mail.mud.yahoo.com>
In-Reply-To: <20061017121825.72937.qmail@web33309.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200610170823.14970.sdavis2@mail.nih.gov>

On Tuesday 17 October 2006 08:18, Sandeep Khandelwal wrote:
> Hi Sean.
>
> The reference that you mentioned is just for Inclusion in the SQL commands
> directly. But.........
>
> I am trying to load coma seperated data using COPY FROM STDIN command (TEXT
> mode) and using PQputCopydata API. COPY FROM STDIN command requires user to
> specify coma seperated text version of all the data.
>
> My question is: If I have binary data(bytea) then I have to convert this
> data into string (char *) form and pass this data to PostgreSQL using
> PQputCopydata API. And, I don't have any API in Libpq to convert binary
> data into string.

Sandeep, 

I see the issue--sorry about the misunderstanding.  I'm not sure what the 
"correct" answer is, but you could simply do base64 client-side encoding and 
decoding of your data.  

Sean