echo work alike in SQL

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

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