Re: echo work alike in SQL

Hi

so 31. 8. 2019 v 17:46 odesílatel stan <stanb(at)panix(dot)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

https://www.postgresql.org/docs/current/app-psql.html

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