Postgres Pro
Downloads
Home   >   mailing lists

Re: Retrieving comment of rules and triggers - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Retrieving comment of rules and triggers
Date
Msg-id CANu8FixMHBXsJ0kXPPK7iP=z4P=q2sErQ84B-XZ-irR6rAw0CQ@mail.gmail.com
Whole thread Raw
In response to Re: Retrieving comment of rules and triggers  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Retrieving comment of rules and triggers  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view


On Thu, Jun 9, 2016 at 5:01 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Jun 9, 2016 at 4:45 PM, Alex Magnum <magnum11200@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 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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Retrieving comment of rules and triggers
Next
From: Adrian Klaver
Date:
Subject: Re: Retrieving comment of rules and triggers