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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
