Thread: echo work alike in SQL
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?
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin
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$
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