Thread: Get RULE condition and commands

What is the proper way of getting RULE condition and commands? The query below does not work.

select pg_get_expr(ev_qual, ev_class, true) as condition,
       pg_get_expr(ev_action, ev_class, true) as commands
from pg_rewrite;

ERROR:  bogus varno: 2

********** Error **********

ERROR: bogus varno: 2
SQL state: XX000

Vlad Arkhipov <arhipov@dc.baikal.ru> writes:
> What is the proper way of getting RULE condition and commands?

pg_get_ruledef()

            regards, tom lane

On 06/16/2012 02:20 AM, Tom Lane wrote:
> Vlad Arkhipov<arhipov@dc.baikal.ru>  writes:
>> What is the proper way of getting RULE condition and commands?
> pg_get_ruledef()
>
>             regards, tom lane
>
It prints the whole CREATE RULE command. Is there any way to extract
WHERE condition of the rule?