Separating raise notice lines

[Radcon Entec <radconentec@xxxxxxxxx>]

I like to use RAISE NOTICE statements to make sure my functions are working correctly.  I just wrote a trigger function that has the following code:

 

    -- We have a new tender.  Find out who it is.
    select into userRecord * from users where users_key = new.tender_key;
    if not found then
 raise exception 'Could not store furnace tender information; no user has a key of %', new.tender_key;
    else
 raise notice 'User name is % %', userRecord.name, chr(10);
    end if;

    -- Now we can store the information.
    insert into furnace_tender_history (area, tender_name, tender_checknum, signin_time, signin_time_utc)
    values (new.area, userRecord.name, userRecord.check_number, current_timestamp, current_timestamp at time zone 'utc');
    raise notice 'History record should be added%', chr(10)::text;
    return new;

I am trying to insert a carriage return character (chr(10)) in the user name notice so that any subsequent notices will appear on separate lines.  However, when I use a query to update a field that will fire this trigger, the Messages tab contains this:

 

NOTICE:  User name is capsNOTICE:  History record should be added
Query returned successfully: 1 rows affected, 16 ms execution time.

How can I get the notices to appear on separate lines?

 

Thanks very much!

 

RobR