Rules in Postgresql

[bogie]

Dear Postgresql forum,

I have some question related to the rules in postgresql. I have a table invention with the following rules

Rules : rule_invention_ insert,
rule_invention_ update,
rule_invention_ delete.

I need to know the inside of this rule, i mean how the relation and so on. Is there any command to see the inside of this rule ?
Please help me. Thank you very much in advance.

Best regards,
Bogie

[rski]

Dear Postgresql forum,

I have some question related to the rules in postgresql. I have a table invention with the following rules

Rules : rule_invention_ insert,
rule_invention_ update,
rule_invention_ delete.

I need to know the inside of this rule, i mean how the relation and so on. Is there any command to see the inside of this rule ?
Please help me. Thank you very much in advance.

Best regards,
Bogie

I'm not sre if I understand but if u want to see the definition of the rule
use the below query
select definition from pg_rules where rulename='your rule name';

[bogie]

I'm not sre if I understand but if u want to see the definition of the rule
use the below query
select definition from pg_rules where rulename='your rule name';

HAlo

Thank you very much for your help, it works.

Best regards,
Bogie