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 vote328 views1 answer
Update using case in mysql
SQL
1 vote354 views3 answers
Nth highest salary
SQL
0 vote330 views1 answer
Postgresql import a database of gzip
SQL
3 votes403 views2 answers
Wp do sql query from function
SQL
0 vote356 views1 answer
Sql query contains multiple ids
SQL
3 votes344 views1 answer
Force using index plsql
SQL
0 vote334 views2 answers
Sql 2 way of select unique
SQL
0 vote340 views1 answer
Less than and between in sql query
SQL
0 vote352 views1 answer
Sql select duplicates based on two columns
SQL
10 votes320 views1 answer
All_dependencies
SQL