Postgres Pro
Downloads
Home   >   mailing lists

Re: echo work alike in SQL - Mailing list pgsql-general

From Pavel Stehule
Subject Re: echo work alike in SQL
Date
Msg-id CAFj8pRB+DY=nqdRDPsdns47kTq+Qt_t0vG=CavovSyGHZqjMEA@mail.gmail.com
Whole thread Raw
In response to echo work alike in SQL  (stan <stanb@panix.com>)
List pgsql-general
Tree view
Hi

so 31. 8. 2019 v 17:46 odesílatel stan <stanb@panix.com> napsal:
Just started using the RAISE functionality to help in debugging.

Tried to add it to an SQL script, only to realize it is a PLPGSQL extension.

Is there a way to get a string to appear in the output f an SQL script?

Can I do some sort of select?

if you run SQL script from psql, then you can use \echo


elsewhere you should to use SELECT

or you can use own function

CREATE OR REPLACE FUNCTION public.debug_text(text)
 RETURNS text
 LANGUAGE plpgsql
AS $function$
BEGIN
  RAISE NOTICE '%', $1;
  RETURN $1;
END;
$function$

Regards

Pavel
 

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin


pgsql-general by date:

Previous
From: stan
Date:
Subject: echo work alike in SQL
Next
From: Tom Lane
Date:
Subject: Re: Question about password character in ECPG's connection string