OK, I've tested both a
COPY BINARY <table> FROM <file>
which was very fast, and now I've also done:
PQputline(conn, <test ascii string>)
the question is, can I combine both techniques, and use a programmatic
interface to copy binary information? We have an data collection application
which needs to insert a huge amount of (binary) information very quickly, so
I'm interested in squeezing out every last CPU cycle. (any other tips you
have will also be appreciated). Thanks