Home > mailing lists

COPY and binary data - Mailing list pgsql-general

From	Юрий EGO
Subject	COPY and binary data
Date	June 9, 2011 17:28:31
Msg-id	E1QTvgs-0006z8-00.mail_ego-list-ru@f3.mail.ru Whole thread Raw
List	pgsql-general

Tree view

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:

From: John R Pierce
Date: 09 June 2011, 15:00:35
Subject: Re: postgres server on windows with high availability and failover safe

From: Clemens Schwaighofer
Date: 09 June 2011, 22:05:54
Subject: Re: plpgsql function with update and seeing changed data from outside during run

COPY and binary data - Mailing list pgsql-general

Previous

Next