Listing of Rules within psql?

Started by Hans Plumalmost 24 years ago2 messagesgeneral
Jump to latest
#1Hans Plum
plum@giub.uni-bonn.de

Hello PostgreSQl-Users,
I am looking for a meta-command within psql to get a listing of my rules. I could not find one neither in 2 different books nor in the interactive documentation.
Is somebody out there who can give me an advice?

Thanks a lot,
Hans
______________________________________________________________________________
Für alle, die nicht genug WEB.DE bekommen können. 100 MB Speicher, SMS Preisvorteil
und noch mehr Kommunikation unter http://club.web.de/?mc=021101

#2Joel Burton
joel@joelburton.com
In reply to: Hans Plum (#1)
Re: Listing of Rules within psql?

SELECT * FROM pg_rules;

Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant

Show quoted text

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Hans Plum
Sent: Sunday, May 05, 2002 10:59 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Listing of Rules within psql?

Hello PostgreSQl-Users,
I am looking for a meta-command within psql to get a listing of
my rules. I could not find one neither in 2 different books nor
in the interactive documentation.
Is somebody out there who can give me an advice?

Thanks a lot,
Hans
__________________________________________________________________
____________
F�r alle, die nicht genug WEB.DE bekommen k�nnen. 100 MB
Speicher, SMS Preisvorteil
und noch mehr Kommunikation unter http://club.web.de/?mc=021101

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster