By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,961 Members | 1,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,961 IT Pros & Developers. It's quick & easy.

Rules in Postgresql

P: 10
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
Sep 13 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
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';
Sep 13 '07 #2

P: 10
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
Sep 13 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.