Lee Kindness <[EMAIL PROTECTED]> writes: > However, is COPY BINARY meant/designed to be used as transfer or > backup mechanism?
I think you're overlooking a key consideration: COPY BINARY is not an isolated feature anymore. By design it uses the same data representations as are used for binary query parameters and results in the rest of the 7.4 FE/BE protocol. I could see some value in providing byte-swapping routines in libpq to convert between local and network representations for integers and floats. The underlying facilities (ntohl etc) are readily available, of course, but it's a small matter that is easy to get wrong. I'm not sure it's worth packaging up COPY BINARY logic per se. I think you'd end up with an API not materially simpler than dealing with the format directly. And I'm unconvinced it'd actually be used widely, whereas I do expect binary transfer of individual values to be common. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster