Em 06/09/2012 09:21, Albe Laurenz escreveu:
Edson Richter wrote:
2) Is there a way to specify the default schema in JDBC url
(or command I can issue to change
the default schema at runtime, like "set path...")?
SET search_path=schema1,schema2,public;
Problem is that my application uses JDBC and Connection Pooling. After
a
connection is closed, I'll have to set search path again, and again...
Nevertheless, connection pool allows me to have one command to test is
connection is available, I'll try to put SET search_path on there, and
see results.
I see.
You could change the default setting for the user with
ALTER ROLE someuser SET search_path=...
That is perfect! I can have separate users for each application, and
then they will have the correct search path.
You saved my day,
Thank you very much!
Edson
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
