Use carriage return with copy in PostgreSQL

From: Sergio Alonso <seralonso1014(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Use carriage return with copy in PostgreSQL
Date: 2021-05-14 17:29:29
Message-ID: CAKJnNEvgqHeKL6XUTxjf5kXqCEq3cKPx01Qfsb0RXakwGSB5qw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am trying to do a COPY from psql, but I need to use the carriage return,
I understand that for LINUX servers by default it is used \n and in windows
it is \r, this I am trying to do on a server with CentOS 7 and
postgreSQL-11, the little test I'm doing is the following:

postgres=# COPY (SELECT C1 FROM (VALUES ('TEST one\r\n' ), ('TEST
two\r\n'),('TEST Three \r \n')) AS t (C1)) TO '/home/postgres/demo.out';
And the result is the following:

TEST one\\r\\n
TEST two\\r\\n
TEST Three \\r \\n
In my opinion, this result or output of the copy process is wrong, or if it
is the opposite, I hope you can help me, thank you!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2021-05-14 18:49:41 Re: Use carriage return with copy in PostgreSQL
Previous Message rammohan ganapavarapu 2021-05-14 14:11:36 Re: Changing wal_level