Re: How to see function & triggers definition?

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

""Hiren Gajjar"" <gajjar(dot)hiren(at)gmail(dot)com>, haber iletisinde sunlari yazdi:fe793ec80607140538j9440da8g5a744346d61ff7cb(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
Hi,

Could anyone help me with this. I want to see the definition of functions & triggres for a perticular table of database.
How do I do this? How do I find whether is it Postgres SQL block or implemented in C/C++?

Thanks & Regards,
Hiren.