AW: Listing rules !!!

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(dot)hartwig(at)t-systems(dot)de
Internet: http://www.t-systems.de

> -----Ursprüngliche Nachricht-----
> Von: Luis Sousa [mailto:llsousa(at)ualg(dot)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
>