Message-ID: <92a8b8b9-2ea9-d079-de64-c18380f1bc11@openvistas.net>
Date: Thu, 3 Nov 2022 15:44:41 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.4.1
Subject: Re: Can psycopg2 copy_expert read from an io.StringIO() buffer?
Content-Language: en-US
To: psycopg@lists.postgresql.org
References: <6dfed0bf-a52a-66c0-43a9-6258d7b9843b@openvistas.net>
 <CA+mi_8Yf6_cRgDjSuFt7px=g7=skjrx_73Pb3qBDwEiasEKgfQ@mail.gmail.com>
From: Jeff Ross <jross@openvistas.net>
In-Reply-To: 
 <CA+mi_8Yf6_cRgDjSuFt7px=g7=skjrx_73Pb3qBDwEiasEKgfQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/92a8b8b9-2ea9-d079-de64-c18380f1bc11%40openvistas.net>
Precedence: bulk

On 11/3/22 2:42 PM, Daniele Varrazzo wrote:
> Hello Jeff,
> 
> On Thu, 3 Nov 2022 at 21:15, Jeff Ross <jross@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