sending data with COPY SQL command, libpq and structure of SELECT resulting buffer

Поиск
Список
Период
Сортировка
От Adam Radlowski
Тема sending data with COPY SQL command, libpq and structure of SELECT resulting buffer
Дата
Msg-id 47208778.2060603@informatyka.gdansk.pl
обсуждение исходный текст
Список pgsql-admin
I sent this message to INTERFACES, but there is no answer, maybe on
ADMIN list somebody knows something about it...
====================
 From the docs i understood, that with COPY SQL command we should use
for synchr. sending:
PQexec
PQResultstatus returns PGRES_COPY_OUT
PQputCopyData
PQputCopyEnd
PQResultstatus returns PGRES_COMMAND_OK

How should look the structure of buffer in
int PQputCopyData(PGconn *conn,const char *buffer,int nbytes);
id for me clear (it should be the same like for example in text dumps of
tables done with pg_dump).

The question is:
Can I in function:
int PQputCopyData(PGconn *conn,const char *buffer,int nbytes);
use as a result buffer directly given by using PQexec for SELECT SQL
command ?
In other way:
Is the structure given as result of PQexec with SELECT SQL command
directly usable as buffer for PQputCopyData ?
======================
Brgds
Adam


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Ewald Geschwinde"
Дата:
Сообщение: create foreign key without checking
Следующее
От: Craig McElroy
Дата:
Сообщение: Re: Problem with PITR Past Particular WAL File