Home

Advanced Examples

Multi-line text strings

UPDATE test
SET values = 'one
two
three';

are concatenated with \n, injecting E in front, if it is not there:

UPDATE test SET values = E'one\ntwo\nthree';