pgsql查看字段數據類型函數?
SELECT pg_proc.proname AS "函數名稱", pg_type.typname AS "返回值數據類型", pg_proc.pronargs AS "參數個數" FROM pg_proc JOIN pg_type ON (pg_proc.prorettype = pg_type.oid) WHERE pg_type.typname != 'void' AND pronamespace = (SELECT pg_namespace.oid FROM pg_namespace WHERE nspname = 'public');