On Thu, Jun 9, 2016 at 5:01 PM, David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Thu, Jun 9, 2016 at 4:45 PM, Alex Magnum <magnum11...@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. >> > > > https://www.postgresql.org/docs/devel/static/functions-info.html > > 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. > > -- 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.
