AW: Listing rules !!!

Поиск
Список
Период
Сортировка
Искать

AW: Listing rules !!!

От:
"Hartwig Jens" <Jens.Hartwig@t-systems.de>
Дата:
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
FAQ