Re: Can psycopg2 copy_expert read from an io.StringIO() buffer?

[Jeff Ross]

On 11/3/22 2:42 PM, Daniele Varrazzo wrote:

Hello Jeff,

On Thu, 3 Nov 2022 at 21:15, Jeff Ross <jr...@openvistas.net> wrote:

         publisher_copy_cursor.copy_expert(copy_query,csv_buf,size)
          subscriber_copy_cursor.copy_expert(insert_query,csv_buf)

Yes, StringIO works ok with copy_expert(). I think you need a
csv_buf.seek(0) between these two statements: after copying data in
the file, the file pointer will be at the end.

Cheers

-- Daniele

Indeed that did fix the problem!

THANKS!!!!!

Jeff