AW: Listing rules !!! - Mailing list pgsql-admin

From Hartwig Jens
Subject AW: Listing rules !!!
Date
Msg-id 819FEEAC94E6DC459F1FDC83C0C1611F1BCC62@mail2000.b3.dsh.de
Whole thread Raw
List pgsql-admin
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

pgsql-admin by date:

Previous
From:
Date:
Subject: Postgres Benchmarks?
Next
From: "Tauren Mills"
Date:
Subject: RE: Limiting simultaneous connections