|
Hi,
this can be help you;
XYZ: function/trigger name
SELECT p.proname AS name, p.oid, p.proargtypes AS
args, ds.description , p.prorettype AS rettype, p.proretset, p.proisstrict AS
strict, p.prosrc AS body, l.lanname AS lang, u.usename, p.prosecdef,
p.provolatile, p.proisagg, n.nspname, proargnames FROM pg_proc p LEFT OUTER JOIN
pg_description ds ON ds.objoid = p.oid INNER JOIN pg_namespace n ON
p.pronamespace = n.oid INNER JOIN pg_language l ON l.oid = p.prolang INNER JOIN
pg_user u ON u.usesysid = p.proowner WHERE p.proname = 'XYZ' AND
lower(n.nspname) = 'public' ORDER BY p.proname, n.nspname
|
