Postgres Pro
Downloads
Home   >   mailing lists

Thread: Retrieving comment of rules and triggers

Retrieving comment of rules and triggers

From
Alex Magnum
Date:
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

Re: Retrieving comment of rules and triggers

From
"David G. Johnston"
Date:
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.

Re: Retrieving comment of rules and triggers

From
Melvin Davidson
Date:


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.

Re: Retrieving comment of rules and triggers

From
Adrian Klaver
Date:
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

Re: Retrieving comment of rules and triggers

From
Melvin Davidson
Date:


On Thu, Jun 9, 2016 at 5:03 PM, Melvin Davidson <melvin6925@gmail.com> wrote:


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.

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.

Re: Retrieving comment of rules and triggers

From
Michael Paquier
Date:
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