Re: Retrieving comment of rules and triggers

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Jun 9, 2016 at 4:45 PM, Alex Magnum <magnum11200@xxxxxxxxx> 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.