Обсуждение: Retrieving comment of rules and triggers
Hi, is there a way to retrieve the comment of rules and triggers. I worked it out on functions, tables, views but am kind of stuck with rules and triggers.
Any help is appreciated.
Thanks
Alex
Hi, is there a way to retrieve the comment of rules and triggers. I worked it out on functions, tables, views but am kind of stuck with rules and triggers.
Table 9-63. Comment Information Functions
obj_description(object_oid, catalog_name)
Catalog Names:
pg_trigger
pg_rules
The source catalog for the data is:
pg_description
I'm suspect of your existing solution given that this is supposed to be a universal interface for comment data...
David J.
On Thu, Jun 9, 2016 at 5:01 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
Hi, is there a way to retrieve the comment of rules and triggers. I worked it out on functions, tables, views but am kind of stuck with rules and triggers.Table 9-63. Comment Information Functionsobj_description(object_oid, catalog_name)Catalog Names:pg_triggerpg_rulesThe source catalog for the data is:pg_descriptionI'm suspect of your existing solution given that this is supposed to be a universal interface for comment data...David J.
-- To get all rule comments
SELECT DISTINCT r.rulename,
c.description
FROM pg_rewrite r
JOIN pg_description c ON c.objoid = r.oid;
-- To get all trigger comments
SELECT DISTINCT t.tgname,
c.description
FROM pg_trigger t
JOIN pg_description c ON c.objoid = t.oid;
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
On 06/09/2016 01:45 PM, Alex Magnum wrote: > Hi, is there a way to retrieve the comment of rules and triggers. I > worked it out on functions, tables, views but am kind of stuck with > rules and triggers. > > Any help is appreciated. > Thanks > Alex From psql: \dd some_rule_name \dd some_trigger_name -- Adrian Klaver adrian.klaver@aklaver.com
On Thu, Jun 9, 2016 at 5:03 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
-- To get all rule commentsOn Thu, Jun 9, 2016 at 5:01 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:Hi, is there a way to retrieve the comment of rules and triggers. I worked it out on functions, tables, views but am kind of stuck with rules and triggers.Table 9-63. Comment Information Functionsobj_description(object_oid, catalog_name)Catalog Names:pg_triggerpg_rulesThe source catalog for the data is:pg_descriptionI'm suspect of your existing solution given that this is supposed to be a universal interface for comment data...David J.
SELECT DISTINCT r.rulename,
c.description
FROM pg_rewrite r
JOIN pg_description c ON c.objoid = r.oid;
-- To get all trigger comments
SELECT DISTINCT t.tgname,
c.description
FROM pg_trigger t
JOIN pg_description c ON c.objoid = t.oid;
--Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
FYI, in the future, it is always best to give your version of PostgreSQL & O/S, as the developers have a nasty habit of changing
pg_catalog tables/columns.
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
On Fri, Jun 10, 2016 at 6:06 AM, Melvin Davidson <melvin6925@gmail.com> wrote: > as the developers have a nasty habit of changing pg_catalog > tables/columns. ... When necessary to improve the quality of the project and the user experience. -- Michael