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.94.2)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1rtsBz-000TVl-1g
	for psycopg@arkaria.postgresql.org; Mon, 08 Apr 2024 16:49:59 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1rtsBx-00A9jP-UZ
	for psycopg@arkaria.postgresql.org; Mon, 08 Apr 2024 16:49:57 +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.94.2)
	(envelope-from <python@aryehleib.com>)
	id 1rtsBx-00A9iy-M2
	for psycopg@lists.postgresql.org; Mon, 08 Apr 2024 16:49:57 +0000
Received: from mout-p-202.mailbox.org ([2001:67c:2050:0:465::202])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <python@aryehleib.com>)
	id 1rtsBp-001bLv-Ez
	for psycopg@postgresql.org; Mon, 08 Apr 2024 16:49:56 +0000
Received: from smtp2.mailbox.org (smtp2.mailbox.org
 [IPv6:2001:67c:2050:b231:465::2])
	(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-202.mailbox.org (Postfix) with ESMTPS id 4VCw6w1mYRz9sR3
	for <psycopg@postgresql.org>; Mon,  8 Apr 2024 18:49:44 +0200 (CEST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aryehleib.com;
	s=MBO0001; t=1712594984;
	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=VJPSIptDTaWn8L9mUkDb7y6AJRVang+8Ufc6/XN5cwo=;
	b=VQN4OewenNC27DLIg5kjydpbDTY1zQtn/9r6WMDp1NjYRl9Fvk3ROWzi8tA/Af9s9+fUJ5
	XEaEpYwvcYywyByqoyqmvW1RGbD31C6NE+XOmf42bzatOex1/Q4pLe5p4TbZ9bIMXfmK9W
	8gEwi/5/W5/7x3YVKzlO3u3w6Jva6eTvcNtG94Kuh1rEQaXtHGbpQdcgUnCeBVvaresRIO
	xRLc7i4qcWlJPFk0X9fr7qYJo5iJWRQl4Yb/ryqDUD1D7nYGFIa5p8Wa/HDX2lbf59CUcR
	om75xzM/svN3wyVL4lnuCAMgq8sKqIluVNpVj0h5MsYA2HXVa0/Lv+lP/I10Jw==
Date: Mon, 8 Apr 2024 19:49:42 +0300
From: Aryeh Leib Taurog <python@aryehleib.com>
To: psycopg@postgresql.org
Subject: pgcopy 1.6.0 release announcement
Message-ID: <ZhQgJsOIDLDx/JPK@xi.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: 4VCw6w1mYRz9sR3
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/ZhQgJsOIDLDx/JPK%40xi.aryehleib.com>
Precedence: bulk

I’m pleased to announce the release of pgcopy 1.6.0!
https://pgcopy.readthedocs.io/

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

Features:
* Supports many datatypes
* Supports on-disk or in-memory cache
* Supports explicit db schema
* Tested with Python 3.8 - 3.12
* Tested with PostgreSQL 12 - 16

This release adds:
* support for the pgvector vector type
* mixed-case table and column names
* proper handling of exceptions in threaded copy execution