Re: Question Regarding COPY Command Handling of Line Breaks in PostgreSQL

2025-07-11 Thread Adrian Klaver
On 7/11/25 06:07, Ron Johnson wrote: On Fri, Jul 11, 2025 at 8:20 AM gzh > wrote: What PG version? What's the full command (including both shell and SQL commands)? Also provide a sample of the original exported data and a sample of the data after it is imported. --

Re: Question Regarding COPY Command Handling of Line Breaks in PostgreSQL

2025-07-11 Thread Ron Johnson
On Fri, Jul 11, 2025 at 8:20 AM gzh wrote: > Dear, > > I am encountering an issue with the COPY command in PostgreSQL regarding > the handling of line breaks in data fields. My PostgreSQL instance is > installed on a Linux system. > > When I use the COPY command to export data to a CSV file and t

Question Regarding COPY Command Handling of Line Breaks in PostgreSQL

2025-07-11 Thread gzh
Dear, I am encountering an issue with the COPY command in PostgreSQL regarding the handling of line breaks in data fields. My PostgreSQL instance is installed on a Linux system. When I use the COPY command to export data to a CSV file and then import the same CSV file back into the database,