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

23 votes157 views6 answers
Create table sql server
SQL
0 vote137 views2 answers
Mysql output csv
SQL
2 votes193 views3 answers
Xampp mysql database not starting
SQL
0 vote142 views1 answer
Find invalid datetime field
SQL
0 vote133 views1 answer
How to check which sp is running in sql server
SQL
1 vote149 views4 answers
Mysqldump 1 table only
SQL
42 votes217 views6 answers
Sql query duplicate rows
SQL
0 vote289 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
6 votes143 views2 answers
Mysql execute file
SQL
0 vote162 views1 answer
Postgres full text search example
SQL