Re: Problem for access schema in postgresl via JDBC

You can set search_path for given user with "alter user set search_path"

2012/2/15 Deiverson Silveira <deiverson(at)solutioncms(dot)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(at)fastcrypt(dot)com>
>
>> On Wed, Feb 15, 2012 at 8:43 AM, Deiverson Silveira
>> <deiverson(at)solutioncms(dot)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
>>
>
>
>
> --
> *
> www.solutioncms.com
> The Brazilian
> Official Provider OpenCms
> *
>

--
Best regards,
Vitalii Tymchyshyn