This is true. I'm the maintainer of pg8000, a Python driver for PostgreSQL. Here are the docs for how you'd do this using pg8000: https://github.com/tlocke/pg8

This is true. I'm the maintainer of pg8000, a Python driver for PostgreSQL. Here are the docs for how you'd do this using pg8000: https://github.com/tlocke/pg8000#copy-from-and-to-a-file https://github.com/tlocke/pg8000#copy-from-and-to-a-file The standard API for database access in Python is DB-API 2 and it doesn't include support for COPY , so each driver may implement it differently. There's another aspect to this, and that's the format of the file to be ingested as it can be 'text', 'CSV' or 'binary'. If you're generating the file yourself then you have a choice, but whether 'binary' is faster than 'CSV' I just don't know.