From: | "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar> |
---|---|
To: | "'Bart van Houdt'" <bart(dot)van(dot)houdt(at)syfact(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Display message to user |
Date: | 2008-11-04 13:24:52 |
Message-ID: | C1B8BE358D7540FEBD3B4D63DE18D0BF@iptel.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi Bart,
If you are using psql then you can get rid of those messages by entering on
the psql prompt:
\set verbose TERSE
If you are using pgAdmin, sadly there is currently no way for this
application to filter context messages.
Regards,
Fernando
_____
De: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org]
En nombre de Bart van Houdt
Enviado el: Martes, 04 de Noviembre de 2008 10:32
Para: pgsql-sql(at)postgresql(dot)org
Asunto: [SQL] Display message to user
Hi all,
I am a Postgres-newbie and working on porting our code from Oracle to
Postgres.
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 notify users of the progress being made during the execution of a
script.
Is there a way to do this with Postgres as well?
I have tried using 'RAISE NOTICE', but using this some extra lines are
printed on screen. Those extra lines mess up the screen and will confuse the
users. The extra lines shown are:
CONTEXT: SQL statement "SELECT migration_pkg.time_migration( $1 , $2 )"
PL/pgSQL function "check_migration" line 34 at PERFORM
Any help would be appreciated,
Bart van Houdt
Syfact International B.V.
Database developer
From | Date | Subject | |
---|---|---|---|
Next Message | Bart van Houdt | 2008-11-04 14:08:57 | RE: [SQL] Display message to user |
Previous Message | Bart van Houdt | 2008-11-04 12:31:56 | Display message to user |