Re: how to list rules? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: how to list rules?
Date
Msg-id 20050914131948.GA24504@winnie.fuhr.org
Whole thread Raw
In response to how to list rules?  (Oleg <evdakov@iwk.uka.de>)
List pgsql-general
On Wed, Sep 14, 2005 at 10:05:15AM +0200, Oleg wrote:
> I am new to PostgreSQL. I am experementing with rules. There is a way to
> create and drop rules but I did not find a way to list all existing
> rules. How do I view rules that I have?

In psql "\d tablename" shows a table's rules; otherwise you could
query the pg_rules system view.

http://www.postgresql.org/docs/8.0/interactive/view-pg-rules.html

--
Michael Fuhr

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: oracle's first_value function for postgres?
Next
From: "ravi chotalia"
Date:
Subject: buffer manager