Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1w2Zxo-000PgL-0o
	for psycopg@arkaria.postgresql.org;
	Tue, 17 Mar 2026 19:20:24 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1w2Zxl-004J2i-2g
	for psycopg@arkaria.postgresql.org;
	Tue, 17 Mar 2026 19:20:21 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <python@aryehleib.com>)
	id 1w2Zxl-004J2Z-1y
	for psycopg@lists.postgresql.org;
	Tue, 17 Mar 2026 19:20:21 +0000
Received: from mout-p-201.mailbox.org ([2001:67c:2050:0:465::201])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <python@aryehleib.com>)
	id 1w2Zxi-00000000eoP-2pMU
	for psycopg@postgresql.org;
	Tue, 17 Mar 2026 19:20:21 +0000
Received: from smtp102.mailbox.org (smtp102.mailbox.org
 [IPv6:2001:67c:2050:b231:465::102])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest
 SHA256)
	(No client certificate requested)
	by mout-p-201.mailbox.org (Postfix) with ESMTPS id 4fb1xj5Cbxz9tkt
	for <psycopg@postgresql.org>; Tue, 17 Mar 2026 20:20:09 +0100 (CET)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aryehleib.com;
	s=MBO0001; t=1773775209;
	h=from:from:reply-to:subject:subject:date:date:message-id:message-id:
	 to:to:cc:mime-version:mime-version:content-type:content-type:
	 content-transfer-encoding:content-transfer-encoding;
	bh=D0558f2Qg8XJ2Z2qaS8X3+RYSvZGaKeYH4U0tqNPMdY=;
	b=FMPonQkZ2R+41AE1SP0CdWGkfgrMfgDcr2/YsQ/YYK/MW3DPw5Gzdy6CHqxyWWhLS29gol
	F8bC0jknoDJnbVNqWMwwmTCBIL7LgjqyO7E5vJxil6GdIQtoPnX4FB9UvcVoBr1s/ZCeoD
	F89I41coSfuZssrZPDWIDvyYJocZmDbF/frQmSHLj2wxIGHZcEBkN7gmLN/dRmRxgPTWvr
	iXNo3YJ2u53obocvz55VLze1Fvjs/ZBYDB/t6X7QWNroET7Yi8H67vHnBBzO8fFlMczkHU
	i+GjHVHggCF1Jz+3Tp+yPU/dDQ0kLEXWUzkQvq9Fk5HZ6BbRfgls+Pe7a8aSgA==
Authentication-Results: outgoing_mbo_mout;
	dkim=none;
	spf=pass (outgoing_mbo_mout: domain of python@aryehleib.com designates
 2001:67c:2050:b231:465::102 as permitted sender)
 smtp.mailfrom=python@aryehleib.com
Date: Tue, 17 Mar 2026 21:20:00 +0200
From: Aryeh Leib Taurog <python@aryehleib.com>
To: psycopg@postgresql.org
Subject: pgcopy 2.0a1
Message-ID: <abmpYL23eLDHgecL@d13.aryehleib.com>
Mail-Followup-To: psycopg@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
X-Rspamd-Queue-Id: 4fb1xj5Cbxz9tkt
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Archived-At: 
 <https://www.postgresql.org/message-id/abmpYL23eLDHgecL%40d13.aryehleib.com>
Precedence: bulk

I’m pleased to announce that pgcopy 2.0a1 is available!
https://pgcopy.readthedocs.io/en/2.0a1/

Use pgcopy with psycopg2 to load large datasets into your database 
quickly using PostgreSQL’s binary copy feature.

This prerelease version adds support for multiple db adaptors.
The db adaptor is automatically detected from the connection.

The following adaptors are supported:

* psycopg2
* psycopg
* pg8000
* PyGreSQL

In addition, the test suite now includes Aurora DSQL
https://aws.amazon.com/rds/aurora/dsql/

Please try this new version and submit feedback via github issues
https://github.com/altaurog/pgcopy/issues