備忘録
SELECT format_type(p.prorettype, NULL) as “Result data type”,
p.proname as “Name”,
oidvectortypes(p.proargtypes) as “Argument data types”
FROM pg_proc p
WHERE p.prorettype <> 0 AND (pronargs = 0 OR oidvectortypes(p.proargtypes) <> ”)
AND
p.oid > (SELECT datlastsysoid FROM pg_database WHERE datname = ‘template1′)
ORDER BY 2, 1, 3;

Tweet