Re: How to see function & triggers definition?
| От | ALI ÇELIK |
|---|---|
| Тема | Re: How to see function & triggers definition? |
| Дата | |
| Msg-id | e9a84o$1c0n$2@news.hub.org обсуждение исходный текст |
| Ответ на | How to see function & triggers definition? ("Hiren Gajjar" <gajjar.hiren@gmail.com>) |
| Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: