Postgresqlで関数とViewを確認する |

単純に、関数、View を一覧表示する

関数を一覧表示

SELECT 
n.nspname || '.' || p.proname || '(' || pg_catalog.oidvectortypes(p.proargtypes) || ')'
FROM pg_catalog.pg_proc p
    LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE p.prorettype <> 'pg_catalog.cstring'::pg_catalog.regtype
     AND p.proargtypes[0] <> 'pg_catalog.cstring'::pg_catalog.regtype
     AND NOT p.proisagg

SELECT

n.nspname || '.' || p.proname || '(' || pg_catalog.oidvectortypes(p.proargtypes) || ')'

FROM pg_catalog.pg_proc p

LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace

WHERE p.prorettype <> 'pg_catalog.cstring'::pg_catalog.regtype

AND p.proargtypes[0] <> 'pg_catalog.cstring'::pg_catalog.regtype

AND NOT p.proisagg

Viewを一覧表示

SELECT viewname, definition FROM pg_views;

1	SELECT viewname, definition FROM pg_views;

すこし、余分なものも出てるけど