Thread: Specify schema in jdbc connection string?

Is there any way to specify which schema I want to use (or have at the
front of the search path) within the jdbc connection string?

I've seen several people asking for the feature in the archives, one
person saying they wrote it but the patch was rejected, but not
authoritative answers...

Thanks,

Dan

--
****************************
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/

On Thu, 8 Dec 2005, Dan Armbrust wrote:

> Is there any way to specify which schema I want to use (or have at the front
> of the search path) within the jdbc connection string?

No.  It is still an open todo open.
http://jdbc.postgresql.org/todo.html

Kris Jurka

Kris Jurka <books@ejurka.com> writes:
> On Thu, 8 Dec 2005, Dan Armbrust wrote:
>> Is there any way to specify which schema I want to use (or have at the front
>> of the search path) within the jdbc connection string?

> No.  It is still an open todo open.

Depending on what you need, it might be an adequate workaround to set
per-user search paths via ALTER USER.

            regards, tom lane