Hi, Would it be possible to create a table or index in a schema without prefixing the schema name? I find it a hassle to keep specifying the schema name when I create an object or performing DMLs in a schema. The search_path configuration works only for queries.
For example: Is there a way to run the create/insert statements below without prefixing the schema name, user1? As the user, user1: Create table user1.table1 (id int); Insert into user1.table1 values (1); Thanks.