PostgreSql not splitting string by new line

Question

I can't make PostgreSql split a string into multiple strings based on newline characters. I have tried splitting by: \n, \r, \r\n. But it's not working!

Not working code:

SELECT string_to_array('Test1
Test2', '\r\n')

Working code (newline character copied directly from text, but it is displayed as invisible \r\n or CRLF):

SELECT string_to_array('Test1
    Test2', '
')

Initial data - a table, the content of which is imported from a .csv file.

What am I doing wrong?

A.Copter · Accepted Answer · 2022-10-05 14:19:20Z

3

After a quick search for "Postgresql Newline character", I've found PostgreSQL newline character

Copied Answer:

the backslash has no special meaning in SQL, so '\n' is a backslash followed by the character n
To use "escape sequences" in a string literal you need to use an "extended" constant:

In your case

SELECT string_to_array('Test1
Test2', E'\n')

Result

string_to_array
{Test1,Test2}

answered Oct 5, 2022 at 14:19

A.Copter

3701 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

PostgreSql not splitting string by new line

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