Re: Retrieving comment of rules and triggers

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Alex Magnum <magnum11200(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Retrieving comment of rules and triggers
Date: 2016-06-09 21:01:22
Message-ID: CAKFQuwa=3mpNkMfb+h-9krwYEjwZPNJ4cOHzX-kDi0+3xXuUtw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 9, 2016 at 4:45 PM, Alex Magnum <magnum11200(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2016-06-09 21:03:17 Re: Retrieving comment of rules and triggers
Previous Message Alex Magnum 2016-06-09 20:45:13 Retrieving comment of rules and triggers