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

14 votes134 views1 answer
Oracle alter table add column not null
SQL
0 vote196 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote141 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote136 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote114 views1 answer
Mysql select where text contains
SQL
0 vote121 views1 answer
Postgresql create table many-to-many
SQL
2 votes124 views1 answer
Sql column values comma separated
SQL
0 vote121 views1 answer
Oracle sql developer closed connection
SQL
0 vote134 views1 answer
Second Step in installing SQL workbench
SQL
-1 vote167 views1 answer
Minus vs except in sql
SQL