Обсуждение: How to see function & triggers definition?
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.
Hiren.
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.hiren@gmail.com>, haber iletisinde şunları yazdı:fe793ec80607140538j9440da8g5a744346d61ff7cb@mail.gmail.com...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.