Preserving new line in postgres column while inserting data in linux

Question

I am trying to insert a row with a string column that contains new line character. The create table statement and insert query are given below.

create table stringtest(id int, inputstr character varying(200));

insert into stringtest values(1,'Name : NOC\r\n\r\nDetail : Detail');

The insert query is executed properly. However when the same row is fetched(when the postgres is in linux), the value of inputstr is not displayed with new line instead it is displayed as

 id |                     inputstr
----+---------------------------------------------------
  1 | Name : NOC\r\n\r\nDetail : Detail

While if we do the same in the windows, we get the resultset as desired as provided below

ngnms=# select * from stringtest;
 id |          inputstr
----+----------------------------
  1 | Site Name : NOC\r         +
    | \r                        +
    | Device Detail : agentdname
(1 row)

what should be done to get the result as desired with the new line instead of escape characters

Point to be added is if the same row is inserted using copy, the new line is preserved properly

I have fixed it by including E before the string with line feed as below insert into stringtest values(1,E'Name : NOC\r\n\r\nDetail : Detail'); — Balachandar
– Balachandar, Commented Oct 31, 2013 at 6:08

Balachandar · Accepted Answer · 2013-10-31 06:10:51Z

5

I have fixed it by including E before the string with line feed as below

insert into stringtest values(1,E'Name : NOC\r\n\r\nDetail : Detail');

answered Oct 31, 2013 at 6:10

Balachandar

1,6383 gold badges17 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Preserving new line in postgres column while inserting data in linux

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related