| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | Sandeep Khandelwal <sandeep_khandelwal27(at)yahoo(dot)com> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Bulk Load and Extract from PostgreSQL |
| Date: | 2006-10-17 12:23:14 |
| Message-ID: | 200610170823.14970.sdavis2@mail.nih.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sandeep Khandelwal | 2006-10-17 12:28:45 | Re: Bulk Load and Extract from PostgreSQL |
| Previous Message | Sandeep Khandelwal | 2006-10-17 12:18:25 | Re: Bulk Load and Extract from PostgreSQL |