Psql list rules

select n.nspname as rule_schema, 
       c.relname as rule_table, 
       case r.ev_type  
         when '1' then 'SELECT' 
         when '2' then 'UPDATE' 
         when '3' then 'INSERT' 
         when '4' then 'DELETE' 
         else 'UNKNOWN' 
       end as rule_event
from pg_rewrite r  
  join pg_class c on r.ev_class = c.oid 
  left join pg_namespace n on n.oid = c.relnamespace 
  left join pg_description d on r.oid = d.objoid ;

Source: stackoverflow.com

Similar codes

1 vote183 views1 answer
Mysql select utc time in eastern time
SQL
0 vote175 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote191 views1 answer
Désinstaller postgresql linux
SQL
0 vote285 views1 answer
Mysql update table from select on another table
SQL
0 vote176 views1 answer
Postgresql newline character
SQL
0 vote207 views1 answer
T-SQL Never ending DELETE
SQL
0 vote206 views1 answer
The fetch keyword oracle
SQL
1 vote212 views1 answer
Oracle select row max date
SQL
0 vote266 views1 answer
<sql:datasource var="Snapsho"
SQL
1 vote204 views1 answer
Mysql remove last empty newline
SQL