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 vote369 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote382 views2 answers
Sql auto update dupdated_at
SQL
2 votes357 views1 answer
Oracle current date without time
SQL
1 vote371 views1 answer
Size of all tables in a schema oracle
SQL
3 votes378 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote381 views1 answer
Oracle activate program
SQL
0 vote340 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote392 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote363 views1 answer
Mysql timediff
SQL
1 vote349 views1 answer
Oracle rolling back transactions
SQL