Display message to user
От | Bart van Houdt |
---|---|
Тема | Display message to user |
Дата | |
Msg-id | CECE69D480C32F49891F27ED3E49C38C048282C9@nthvsexch02.interaccess.nl обсуждение исходный текст |
Ответы |
Re: Display message to user
Re: Display message to user |
Список | pgsql-sql |
<div class="Section1"><p class="MsoNormal">Hi all,<p class="MsoNormal"> <p class="MsoNormal">I am a Postgres-newbie and workingon porting our code from Oracle to Postgres.<p class="MsoNormal">Oracle has a nice package procedure (dbms_output.put_line)to display a message in SQL*Plus, which can display a message to the user. I use this a lot, to notifyusers of the progress being made during the execution of a script. <p class="MsoNormal">Is there a way to do this withPostgres as well?<p class="MsoNormal"> <p class="MsoNormal">I have tried using ‘RAISE NOTICE’, but using this some extralines are printed on screen. Those extra lines mess up the screen and will confuse the users. The extra lines shownare:<p class="MsoNormal"> <p class="MsoNormal">CONTEXT: SQL statement "SELECT migration_pkg.time_migration( $1 , $2 )"<p class="MsoNormal">PL/pgSQL function "check_migration" line 34 at PERFORM<p class="MsoNormal"> <p class="MsoNormal">Anyhelp would be appreciated,<p class="MsoNormal"> <p class="MsoNormal"><b><span lang="NL" style="font-size:10.0pt;font-family:"Arial","sans-serif"; color:#1B5DA7">Bart van Houdt</span></b><p class="MsoNormal"><span lang="NL" style="font-size:10.0pt;font-family:"Arial","sans-serif"; color:black">Syfact International B.V.</span><p class="MsoNormal"><span lang="NL" style="font-size:10.0pt;font-family:"Arial","sans-serif"; color:black">Database developer</span><p class="MsoNormal"> </div>
В списке pgsql-sql по дате отправления: