Date: Fri, 3 Nov 2023 13:58:21 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Noah Misch <noah@leadboat.com>, Svante Richter <pgsql-bugs@richter.id>,
	pgsql-bugs@lists.postgresql.org
Subject: Re: COPY TO CSV produces data that is incompatible/unsafe for \COPY
 FROM CSV
Message-ID: <ZUU0vU0OS4XFpnOV@momjian.us>
References: <bfcd57e4-8f23-4c3e-a5db-2571d09208e2@beta.fastmail.com>
 <20220814070053.GA92855@rfd.leadboat.com>
 <624693.1660486135@sss.pgh.pa.us>
 <Yvu3N9Dn4iA5+8Up@momjian.us>
 <ZT0q_djqSO3d6MQU@momjian.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <ZT0q_djqSO3d6MQU@momjian.us>
Archived-At: 
 <https://www.postgresql.org/message-id/ZUU0vU0OS4XFpnOV%40momjian.us>
Precedence: bulk

On Sat, Oct 28, 2023 at 11:38:37AM -0400, Bruce Momjian wrote:
> On Tue, Aug 16, 2022 at 11:26:47AM -0400, Bruce Momjian wrote:
> > I think at this point we should either fix this or document it.
> 
> I have decided to document this with the attached patch.  I plan to
> apply it to all supported Postgres versions.  If we ever fix FROM file
> so only FROM STDIN is a problem, we can update the documentation.

Patch applied to all supported versions.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.