Postgres Pro
Downloads
Home   >   mailing lists

Re: how to see rules - Mailing list pgsql-general

From Tom Lane
Subject Re: how to see rules
Date
Msg-id 3124.989021501@sss.pgh.pa.us
Whole thread Raw
In response to how to see rules  (Martín Marqués <martin@bugs.unl.edu.ar>)
List pgsql-general
Tree view 
=?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin@bugs.unl.edu.ar> writes:
> I have a par of views and some rules that work with them. How can I
> see which rules I have on a database (psql)?

select * from pg_rules;

            regards, tom lane

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: IpcMemoryCreate: shmget failed (Invalid argument)
Next
From: Tom Lane
Date:
Subject: Re: I lost the pg_control file