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=... Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
