Archive for » 6 月, 2010 «

水曜日, 6 月 30th, 2010 | Author: djodjo

備忘録
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;

Category: 未分類 | Leave a Comment

gdb　子プロセスをおっかける