COPY and binary data - Mailing list pgsql-general

From Юрий EGO
Subject COPY and binary data
Date
Msg-id E1QTvgs-0006z8-00.mail_ego-list-ru@f3.mail.ru
Whole thread Raw
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: John R Pierce
Date:
Subject: Re: postgres server on windows with high availability and failover safe
Next
From: Clemens Schwaighofer
Date:
Subject: Re: plpgsql function with update and seeing changed data from outside during run