Re: libpq PQexec call of COPY
От | Peter Eisentraut |
---|---|
Тема | Re: libpq PQexec call of COPY |
Дата | |
Msg-id | Pine.LNX.4.30.0104101907410.1403-100000@peter.localdomain обсуждение исходный текст |
Ответ на | libpq PQexec call of COPY (John Coers <coers@intrinsity.com>) |
Список | pgsql-hackers |
John Coers writes: > Hi, > > My generic problem is performance when copying very large amounts of data to a db from multiple clients. > > I am writing a C program on Linux Redhat6.2 that accesses a 7.0.3 database using libpq. I > would like to be able to do a printf through STDOUT (or another file pointer) TO the database via a > PQexec call of COPY. Something like this would be ideal: > > PQexec(conn, "COPY moncoverage from STDOUT"); > > I have been unable to figure out if this is possible. I understand that I can do this via stdin, > but I don't want the user to make the entry, I want the executable to do it and still enjoy the > performance of the COPY command. Read the libpq chapter in the Programmer's Guide and look into src/bin/psql/copy.c for information and examples of using COPY through libpq. Yes, it's possible, but you need to use special API calls. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
В списке pgsql-hackers по дате отправления: