... - Mailing list pgsql-general

From Юрий EGO
Subject ...
Date
Msg-id E1QTvfl-00026V-00.mail_ego-list-ru@f279.mail.ru
Whole thread Raw
Responses Re:
List pgsql-general
Hello!

I have a code (libpq):

char textbuffer[120];
res = PQexec(conn, "COPY table_name(\"serial_column",\"int_column",\"bytea_column\") FROM STDIN");
if(PQresultStatus(res) == PGRES_COPY_IN)
{
for(int n=0; n < 10; n++) {
sprintf(textbuffer, "1\t%i\t'text'\n", n);
int copydatares = PQputCopyData(conn, textbuffer, strlen(textbuffer));
}
PQputCopyEnd(conn, NULL);
} 

For text data it's ok, but binary data may have '\n' or '\t' characters.
How  correctly write int STDIN binary data?

Help me please! 
Thanks in advance.

pgsql-general by date:

Previous
From: andreas@a-kretschmer.de
Date:
Subject: Re: maximum size limit for a query string?
Next
From: Merlin Moncure
Date:
Subject: Re: