PostgreSQLに登録したPL/pgSQLの内容を確認する方法
-----------------------------------------
SELECT routine_definition
FROM information_schema.routines
WHERE routine_name = '(関数名)';
-----------------------------------------
(例)
=#
CREATE OR REPLACE FUNCTION hogehoge(INTEGER) RETURNS VOID AS $$
DECLARE
BEGIN
END;
$$ LANGUAGE plpgsql;
=#
SELECT routine_definition
FROM information_schema.routines
WHERE routine_name = 'hogehoge'
-----------------------------------------
参考URL