Re: [GENERAL] Retrieving comment of rules and triggers

2016-06-09 Thread Michael Paquier
On Fri, Jun 10, 2016 at 6:06 AM, Melvin Davidson 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 -- Sent via pgsql-general mailing list

Re: [GENERAL] Retrieving comment of rules and triggers

2016-06-09 Thread Melvin Davidson
On Thu, Jun 9, 2016 at 5:03 PM, Melvin Davidson wrote: > > > On Thu, Jun 9, 2016 at 5:01 PM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Thu, Jun 9, 2016 at 4:45 PM, Alex Magnum >> wrote: >> >>> Hi, is there a way to retrieve the

Re: [GENERAL] Retrieving comment of rules and triggers

2016-06-09 Thread 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 --

Re: [GENERAL] Retrieving comment of rules and triggers

2016-06-09 Thread Melvin Davidson
On Thu, Jun 9, 2016 at 5:01 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Jun 9, 2016 at 4: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

Re: [GENERAL] Retrieving comment of rules and triggers

2016-06-09 Thread David G. Johnston
On Thu, Jun 9, 2016 at 4: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. > ​

[GENERAL] Retrieving comment of rules and triggers

2016-06-09 Thread 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