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 [EMAIL PROTECTED] http://yi.org/peter-e/
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
