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 vote199 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
1 vote239 views1 answer
Oracle create program if not exists
SQL
0 vote171 views1 answer
Mysql create table columns with spaces
SQL
5 votes188 views1 answer
How to check nls format in oracle
SQL
1 vote202 views2 answers
Copy database mysql
SQL
0 vote222 views1 answer
Select distinct after join
SQL
26 votes191 views2 answers
Mysql workbench download
SQL
7 votes212 views1 answer
Buy forge mods server hosting
SQL
1 vote194 views1 answer
Increase date by one day in sql oracle
SQL
3 votes202 views2 answers
Mysql create timestamp column
SQL