how to list rules?

Started by Olegover 20 years ago2 messagesgeneral
Jump to latest
#1Oleg
evdakov@iwk.uka.de

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

#2Michael Fuhr
mike@fuhr.org
In reply to: Oleg (#1)
Re: how to list rules?

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