CREATE OR REPLACE FUNCTION raise_sample() RETURNS void AS $$ DECLARE foo text := 'foo'; bar int := 123; BEGIN RAISE DEBUG 'DEBUG RAISE MESSAGE'; RAISE LOG 'LOG RAISE MESSAGE'; RAISE INFO 'INFO RAISE MESSAGE %', foo; RAISE NOTICE 'NOTICE RAISE MESSAGE %,%', foo, bar; RAISE WARNING 'WARNING RAISE MESSAGE'; END $$ LANGUAGE plpgsql ;