PL/pgSQL Template to run inline a complicated function and get results in console

plpgsql_query_function_template.sql

-- PL/pgSQL Template to run inline a complicated function and get results in console
DO $$
DECLARE
    -- ADD QUERY DECLARATION HERE:
    filteringIdOfSomeKind      UUID;

    -- ADD QUERY DECLARATION HERE -- END!

    t timestamptz;
    target record;

BEGIN
    t := clock_timestamp();
    filteringIdOfSomeKind := '8cae6ff8-b532-4749-94b4-ffc51c933b86';

    RAISE NOTICE 'HELLO THERE filteringIdOfSomeKind = %', filteringIdOfSomeKind;
	RAISE NOTICE '----------------------';
	FOR target IN

    -- ADD CORE PART OF QUERY

        SELECT random()*100 as theId, * FROM generate_series(1,5)


    -- ADD CORE PART OF QUERY -- END! (REMOVE LAST ;)


	LOOP
    -- the only way to address the output is to fetch single fields as this:
	-- RAISE NOTICE 'fieldNameNo1= %', 'target.fieldNameNo1';
	-- RAISE NOTICE 'fieldNameNo2= %', 'target.fieldNameNo2';
    -- ...
    -- or just print the whole thing TODO: add some formatting
	RAISE NOTICE '%', target;

	END LOOP;
	RAISE NOTICE '----------------------';
    RAISE NOTICE 'END BLOCK time spent=%', clock_timestamp() - t;


END; $$;