Re: Problem for access schema in postgresl via JDBC - Mailing list pgsql-jdbc

From Віталій Тимчишин
Subject Re: Problem for access schema in postgresl via JDBC
Date
Msg-id CABWW-d2PUu-QLqzN6KrQNN3Cuaft19kEKZASBOTnnh1PJrJAWg@mail.gmail.com
Whole thread Raw
In response to Re: Problem for access schema in postgresl via JDBC  (Deiverson Silveira <deiverson@solutioncms.com>)
List pgsql-jdbc
You can set search_path for given user with "alter user set search_path"

2012/2/15 Deiverson Silveira <deiverson@solutioncms.com>
Do you have any knowledge to solve this issue? Definition of connection toa schema through the string? 

Regards,

Deiverson

2012/2/15 Dave Cramer <pg@fastcrypt.com>
On Wed, Feb 15, 2012 at 8:43 AM, Deiverson Silveira
<deiverson@solutioncms.com> wrote:
> Hi List,
>
> My client need connect in dbproject, schema intranet.... but I dont work my
> config in opencms.
>
> I try:
> db.pool.intranet.jdbcUrl=jdbc:postgresql://serverdb:5432/dbproject?schema=intranet
> and
> db.pool.intranet.jdbcUrl=jdbc:postgresql://serverdb:5432/dbproject?searchpath=intranet
>
> but dont work, but in schema public work...
>
> Idea? Document very poor:
> http://jdbc.postgresql.org/documentation/83/connect.html
>
> Regards,
>
> Deiverson
>
> --

Where in the docs does it suggest the above will work ?

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca



--
The Brazilian 
Official Provider OpenCms




--
Best regards,
 Vitalii Tymchyshyn

pgsql-jdbc by date:

Previous
From: Віталій Тимчишин
Date:
Subject: Re: non-trivial finalize() on AbstractJdbc2Statement
Next
From: Віталій Тимчишин
Date:
Subject: Re: Upgrade question, going from 8.3 to 9.1...