COPY_FROM async

[sanderfoobar]

Hi,

From the documentation:

COPY commands are not supported either in asynchronous mode, but this will be probably implemented in a future release.

Any idea when we could expect such a feature?

My use case: Using psycopg2 via a txpostgres ConnectionPool in Twisted; needing to do large numbers of inserts asynchronously.

[rad-pat]

Is this enhancement something we might expect in the near future? It has been quite some time since the original issue.

[dvarrazzo]

@rad-pat I do have some time for some free-software development at the moment, but async copy is relatively low in the list: I had in mind to focus on a few other projects first.

If you have interest in that feature please consider sponsoring the development. Thank you very much!

[dvarrazzo]

Asynchronous copy is implemented in psycopg3.

[dan-cbm]

here's a working link for the relevant psycopyg3 docs

https://www.psycopg.org/psycopg3/docs/basic/copy.html#asynchronous-copy-support