how to see rules

Started by Martín Marquésalmost 25 years ago2 messagesgeneral

martin@bugs.unl.edu.ar

almost 25 years ago

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)?

Saludos... :-)

--
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-----------------------------------------------------------------
Martin Marques | mmarques@unl.edu.ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Tom Lane

tgl@sss.pgh.pa.us

almost 25 years ago

In reply to: Martín Marqués (#1)

Re: how to see rules

=?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