Wolf Wiegand schrieb:
Luckily, there is also a SQL version of the \COPY command.
The syntax is similar, but without the backslash.
This doesn't work, though, if I try to insert a local file to a remote
database, using a regular user, right?
The file must be directly accesible for the server process,
so that will not work. But you can use "from stdin" instead:
cat filename | psql -h remotehost -c "copy table from stdin" database
Generally, what I am trying to achieve is to insert quite a large amount
of data as fast as possible to a remote database. Would inserttable be
a reasonable way to do that?
That's exactly what inserttable is intended for. Internally, it uses
"copy from stdin".
-- Christoph
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql
