Database Adaptors

As of version 2.0, pgcopy supports multiple db adaptors. The db adaptor is automatically detected when a connection is passed to pgcopy.CopyManager.

Adaptor

Notes

psycopg2

All features are supported

psycopg

threading_copy is the same as copy. It does not actually use a thread, since psycopg copy is non-blocking.

pg8000

UTF-8 encoding is strongly recommended on both server and client. threading_copy is not supported.

PyGreSQL

UTF-8 encoding is strongly recommended on both server and client. threading_copy is not supported.

Tests

One of psycopg2 or psycopg is required to run the tests. The test suite will automatically discover all supported db adaptors.