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 vote131 views1 answer
Datetime postgres typeorm
SQL
4 votes135 views1 answer
Find tables with column name in sql
SQL
0 vote163 views1 answer
Query to insert image
SQL
0 vote130 views1 answer
Sql composite key
SQL
1 vote168 views1 answer
Mysql default port
SQL
0 vote129 views1 answer
How to count with except in psql
SQL
-1 vote191 views3 answers
MAKE TABLE FIT in oracle sql
SQL
1 vote128 views2 answers
Install mysqldump ubuntu
SQL
0 vote130 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote130 views4 answers
Mysql on kubernetes
SQL