Обсуждение: Retrieving comment of rules and triggers

Поиск
Список
Период
Сортировка

Retrieving comment of rules and triggers

От
Alex Magnum
Дата:
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

От
"David G. Johnston"
Дата:
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

От
Melvin Davidson
Дата:


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

От
Adrian Klaver
Дата:
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

От
Melvin Davidson
Дата:


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

От
Michael Paquier
Дата:
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