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 vote174 views1 answer
Update if else mysql
SQL
2 votes177 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote165 views2 answers
Postgresql display subquery as json
SQL
2 votes187 views2 answers
Mamp connect mysql terminal
SQL
1 vote197 views1 answer
SQL Integer devision
SQL
0 vote206 views1 answer
Codigo crear tablas sql server
SQL
0 vote183 views1 answer
Mysql count with two joins
SQL
1 vote149 views1 answer
Ms sql how to see active job current run time
SQL
0 vote191 views1 answer
Mariadb datetime change to microseconds
SQL
2 votes207 views1 answer
Sql find not in list
SQL