Postgres Pro
Downloads
Home   >   mailing lists

Re: Display message to user - Mailing list pgsql-sql

From Fernando Hevia
Subject Re: Display message to user
Date
Msg-id C1B8BE358D7540FEBD3B4D63DE18D0BF@iptel.com.ar
Whole thread Raw
In response to Display message to user  ("Bart van Houdt" <bart.van.houdt@syfact.com>)
List pgsql-sql
Tree view
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@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] En nombre de Bart van Houdt
Enviado el: Martes, 04 de Noviembre de 2008 10:32
Para: pgsql-sql@postgresql.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

 

 

pgsql-sql by date:

Previous
From: "Bart van Houdt"
Date:
Subject: Display message to user
Next
From: "Bart van Houdt"
Date:
Subject: RE: [SQL] Display message to user