I want to read and write bulk data into PostgreSQL using Libpq C API and right now I am under the investigation phase. Also want to delete and update into PostgreSQL using Libpq API.
PLease let me know
I am planning to use COPY DATA TO command in TEXT mode for reading, I am using PQgetCopydata function to get data one row at a time.
a - Not sure whether PQgetCopydata will give NULL terminated string or \n terminated string.
b - I know that PQgetCopydata API will give data of all the rows , seperated by delimiter, in TEXT format. But don't know how to convert this text data into corresponding data type, especially BYTEA.
c - Don't know what are the special characters and how these are handeled by PQgetCopydata and How I should hendel them.
I am planning to use COPY DATA FROM command in TEXT mode for writing, I am using PQputCopydata function to send data one row at a time.
a - Not sure what are the special characters and how I should miodify them.
b - PQputCopydata API takes data of all the rows, seperated by delimiter, ini string representation. Don't know how to convert all the datatypes into string representation, especially BYTEA.
Waiting for reply.
pgsql-interfaces by date
|Next:||From: Marko Bozikovic||Date: 2006-10-18 07:06:32|
|Subject: Postgres OLE DB provider - query parameters|
|Previous:||From: Francisco Figueiredo Jr.||Date: 2006-10-17 13:33:36|
|Subject: Npgsql 1.0 Released!!|