Answer the question
In order to leave comments, you need to log in
How to add new line to TEXT field of a table?
I have a table, one of whose columns is of type text
.
The question is very simple: What should be written in the INSERT to insert the new line character (\n) into the text?
Because it doesn't work like this:
INSERT INTO t1
(payload)
VALUES
(E'This is the first part \\n And this is the second');
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question