Now Some New Concepts in Postgres

How to have a new line character in a variable in plpgsql ??


Just this code will do


declare
line varchar;
a varchar;
b varchar;
begin
line=chr(10)  ;
a=a || line || b ;

Now you can append this variable to other variables .

Remember, each line of plpgsql must end with semi-color (; )
|| -> Appending Operator