On 13 August 2013 11:43, Tomonari Katsumata < katsumata.tomon...@po.ntts.co.jp> wrote:
> Hi, > > 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.) > > regards, > -------------------- > NTT Software Corporation > Tomonari Katsumata > > > > Could you show an example? Szymon