SEO

#1 (**permalink**) 04-09-2008, 10:37 AM

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.

#2 (**permalink**) 04-09-2008, 10:38 AM

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 sunlari yazdi: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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to see function & triggers definition?