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

25 votes226 views6 answers
How to change column name in mysql
SQL
2 votes196 views1 answer
Postgresql update sequence next value
SQL
0 vote202 views1 answer
Postgres float to int
SQL
10 votes185 views2 answers
Sql where clause multiple values
SQL
0 vote232 views1 answer
Sql show founctions
SQL
0 vote205 views1 answer
Oracle sql generate list of days
SQL
3 votes279 views1 answer
Oracle sql commit example
SQL
0 vote196 views1 answer
Uuid sqlalcomany
SQL
36 votes226 views3 answers
Add column in mysq
SQL
7 votes206 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL