Psql list view 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

0 vote416 views1 answer
Oracle simple quote
SQL
1 vote326 views1 answer
Sql trigger before delete
SQL
0 vote333 views1 answer
Mysql select statement after index
SQL
0 vote530 views1 answer
Dublicate row sql
SQL
6 votes410 views2 answers
Oracle compile trigger
SQL
8 votes343 views2 answers
Sqlsrv default port
SQL
1 vote338 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
1 vote341 views1 answer
Psql search table
SQL
25 votes366 views6 answers
Import database mysql command line
SQL
1 vote348 views2 answers
Postgresql truncate cascade restart identity
SQL