Hello Luis,
have a look at pg_rules (SELECT * FROM pg_rules). Alternatively you
could use pg_rewrite but it is not as easy to read.
Best regards, Jens Hartwig
-----------------------------------------------------
T-Systems
Project Manager
debis Systemhaus GEI GmbH
Address: Eichhornstraße 3, 10785 Berlin
Postal Address: 10785 Berlin
Phone: (004930) 25 54-32 82
Fax: (004930) 25 54-31 87
Mobile: (0170) 167 26 48
E-Mail: jens.hartwig@t-systems.de
Internet: http://www.t-systems.de
> -----Ursprüngliche Nachricht-----
> Von: Luis Sousa [mailto:llsousa@ualg.pt]
> Gesendet: Dienstag, 29. Mai 2001 11:23
> An: pgsql Admin Mailing List
> Betreff: [ADMIN] Listing rules !!!
>
>
> How can i know which rules are activate in my database ??
>
> I can see the tables with \d, the views with \dv and so on
> ..., but for
> the rules ???
>
>
>
>
>
> Thanks
>
> Luis Sousa
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
