New line in a notice.

Hello

I am debugging a plpgsql script putting some RAISE NOTICE '…' in my code but in PG admin III in the "message Panel" all NOTICE messages are in one single line.

It becomes impossible to read it …

So I am looking for any tips helping me to display each NOTICE on a single line.

I have tried \n and chr(10) but without success :’(

I am working on Windows XP, Postgres 8.3 under PGAdmin III

Thank you

Nicolas.

Try \r.  It works in many cases where \n does not

Hello

I am debugging a plpgsql script putting some RAISE NOTICE '…' in my code but in PG admin III in the "message Panel" all NOTICE messages are in one single line.

It becomes impossible to read it …

So I am looking for any tips helping me to display each NOTICE on a single line.

I have tried \n and chr(10) but without success :’(

I am working on Windows XP, Postgres 8.3 under PGAdmin III

Thank you

Nicolas.

Hello,

Thank you for your answer.

Actually had tried this already and it doesn’t work.

The result of

“RAISE NOTICE 'test \r';

RAISE NOTICE 'test \r';”

Is

“NOTICE:  test rNOTICE:  test r”

Same as \n, only ‘n’ char is displayed.

I wonder if it isn’t some kind of difference between windows and unix system for the definition of new line.

In log files, notices are displayed properly, no need of CR/LF characters.

But it is not really convenient to read logs as there’re also some other log info I don’t want to read.

Regards,

Nicolas

Try \r.  It works in many cases where \n does not

Hello

I am debugging a plpgsql script putting some RAISE NOTICE '…' in my code but in PG admin III in the "message Panel" all NOTICE messages are in one single line.

It becomes impossible to read it …

So I am looking for any tips helping me to display each NOTICE on a single line.

I have tried \n and chr(10) but without success :’(

I am working on Windows XP, Postgres 8.3 under PGAdmin III

Thank you

Nicolas.

This message and any enclosures are intended only for the addressee.  Please  

notify the sender by email if you are not the intended recipient.  If you are  

not the intended recipient, you may not use, copy, disclose, or distribute this  

message or its contents or enclosures to any other person and any such actions  

may be unlawful.  Ball reserves the right to monitor and review all messages  

and enclosures sent to or from this email address.