New line character in PostgreSQL

SELECT 'a' || chr(10) || 'b'
SELECT 'a' || E'\n' || 'b'

Know more: