Prefixing schema name - Mailing list pgsql-general

From Tiffany Thang
Subject Prefixing schema name
Date
Msg-id CAB_W-NN2Bx6AseZJrijUMG9M82G9Mi0sRuaUJxeh+9x+1cqp2A@mail.gmail.com
Whole thread Raw
Responses Re: Prefixing schema name  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Help troubleshooting SubtransControlLock problems
Next
From: Jan Bilek
Date:
Subject: cached plan must not change result type