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 vote156 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote215 views1 answer
Tsql cte in a transaction
SQL
1 vote322 views1 answer
Mysql data from file
SQL
0 vote163 views1 answer
What is the essence of SQL?
SQL
1 vote186 views1 answer
Sql random sampling per group
SQL
-1 vote187 views1 answer
Concat two columns in sql server
SQL
0 vote187 views1 answer
Declaring variables in pl sql
SQL
13 votes165 views2 answers
Display users in mysql
SQL
0 vote182 views2 answers
Sql regex vowel
SQL
0 vote211 views1 answer
Select top 3 sql
SQL