S
S
Sland Show2019-06-10 12:24:53
PostgreSQL
Sland Show, 2019-06-10 12:24:53

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');

I tried to find usefulness here , but even does not work.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-06-10
@tsklab

Insert line break in postgresql when updating text... .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question