Re: Rules - Mailing list pgsql-novice

From Einar Karttunen
Subject Re: Rules
Date
Msg-id 20011107152757.A13991@cs.helsinki.fi
Whole thread Raw
In response to Rules  (Seth Milder <mrseth@physics.gmu.edu>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: "calios"
Date:
Subject:
Next
From: Jason Earl
Date:
Subject: Re: