CREATE OR REPLACE FUNCTION raise1() RETURNS void AS $$ DECLARE foo text := 'foo'; bar int := 123; BEGIN INSERT INTO t1 VALUES(1,'foo'),(2,'bar'),(3,'hoge'); 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 ;