You don't have to do anything to stop users updating views. Since a view can summarise a join over several tables, there is no obvious way for Postgres to figure out what an update or insert should do. To allow users to update views see the following section.