title: How to create a read only view in postgresql , similar to oracle?
body: <p>I want to create read only view in PostgreSQL. We can create in Oracle, but unable to do in PostgreSQL.</p>
  
  <p>I tried to create a read only view but I get a syntax error at READ ONLY.</p>
  
  <pre><code>CREATE OR REPLACE VIEW VIEW NAME() 
  from table names 
  where filter condition1=filter 
    condition2 
  with READ ONLY; 
  </code></pre>
  
  <p>But the <code>READ ONLY</code> doesn't work in PostgreSQL. How do I create a read only view in PostgreSQL?</p>