Thread: how to list rules?

Dear all,
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?
Thanks a lot in advance
Oleg

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