Could anyone tell me how to create read-only view on PostgreSQL 9.3 ?
I've been testing updatable views and noticed that all simple views are updatable.
When I use pg_dump for upgrading from PostgreSQL 9.2 to PostgreSQL 9.3 and if the databse has views, all views are updatable on the restored database.
I want to make these views read-only like PostgreSQL9.2. How can I do this? Should I make access control on users ? (Sorry, I couldn't find any explanations on document.)