Thread: Rules

Hi list,

I would like to create a rule to generate running statistics on other
tables. The problem is, after I create a rule, I cannot view it. Is
there a way to display or edit rules in postgres? Also are rules permanent?

Thanks,

Seth

On Tue, Nov 06, 2001 at 10:27:13AM -0500, Seth Milder wrote:
> Hi list,
>
> I would like to create a rule to generate running statistics on other
> tables. The problem is, after I create a rule, I cannot view it. Is
> there a way to display or edit rules in postgres? Also are rules permanent?
>
You can get a listing of all rules with:
SELECT * FROM pg_rules;
To delete a rule use simply:
DROP RULE rulename;

- Einar Karttunen