Skip to content

NEW_LINE ​

Also known as

raw_new_line (with or without @ prefix)

Set the row separator for raw output mode.

Syntax ​

code
@new_line <string>

Supports escape sequences: \n (newline), \r\n (Windows newline), \\ (backslash)

Examples ​

Unix Line Endings ​

sql
sql
comment on function export_unix() is
'HTTP GET
@raw
@separator ,
@new_line \n';

Windows Line Endings ​

sql
sql
comment on function export_windows() is
'HTTP GET
@raw
@separator ,
@new_line \r\n';

Custom Row Separator ​

sql
sql
comment on function export_custom() is
'HTTP GET
@raw
@new_line |||';

Comments