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 vote186 views1 answer
Convert int to varchar sql
SQL
4 votes210 views1 answer
Postgresql create table with index
SQL
13 votes240 views4 answers
Mysql remove foreign key constraint
SQL
1 vote155 views1 answer
Importance of comment in mysql
SQL
2 votes160 views1 answer
How to add where command in update comand with joins
SQL
1 vote183 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
4 votes167 views4 answers
Sqlite describe table
SQL
0 vote162 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote125 views1 answer
Copy table dbeaver
SQL
1 vote181 views2 answers
Mysql trim spaces
SQL