[postgis-users] New line in a notice.

Nicolas Gillet - MARKET-IP nicolas.gillet at market-ip.com
Fri Oct 16 01:36:45 PDT 2009



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';”


“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.






De : postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] De la part de Clay,
Envoyé : jeudi 15 octobre 2009 18:18
À : PostGIS Users Discussion
Objet : Re: [postgis-users] New line in a notice.


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



From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Nicolas
Gillet - MARKET-IP
Sent: Thursday, October 15, 2009 3:31 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] New line in a notice.




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

It becomes impossible to read it 


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

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


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


Thank you



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
not the intended recipient, you may not use, copy, disclose, or distribute
message or its contents or enclosures to any other person and any such
may be unlawful.  Ball reserves the right to monitor and review all messages

and enclosures sent to or from this email address.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091016/cd28c9b0/attachment.html>

More information about the postgis-users mailing list