Re: Enforcing users to write schemas when creating tables

2017-12-20 Thread Laurenz Albe
Gabriel Furstenheim Milerud wrote: > I'm trying to enforce db users to write a schema when creating a table. That > is: > > create table some_schema.my_table (a int); -- should succeed > create my_table (a int); -- should fail > > I don't know if that is possible. > > What I've tried

Enforcing users to write schemas when creating tables

2017-12-20 Thread Gabriel Furstenheim Milerud
Hi, I'm trying to enforce db users to write a schema when creating a table. That is: create table some_schema.my_table (a int); -- should succeed create my_table (a int); -- should fail I don't know if that is possible. What I've tried so far is to create a schema which is first in th