how to list rules?
Started by Olegover 20 years ago2 messagesgeneral
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
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