Re: please help - schema in jdbc connection string

On Wednesday 08 September 2004 10:51, Paul Thomas wrote:
> On 08/09/2004 01:50 Nanu Ram wrote:
> > Hi:
> >
> >
> >
> > I am sorry of this was already answered earlier (I looked - it was
> > asked, but didn't find the ans.). Has this been implemented?
> >
> > I would like to connect to one of the schema's in my database, something
> > likes this ...
> >
> >
> >
> > jdbc:postgresql://<host>:5432/<db>?schema=<schema1>
> >
> >
> >
> > I am on 7.4.3
>
> You don't connect to schemas, you connect to databases.

I don't think that's the answer hi's looking for. What he needs is setting the
default search_path to <schema> before he can operate on the db, and he
doesn't want to do it programmaticly(which I understand why). I think this is
perfectly valid and makes sence. I made a patch to the JDBC driver to allow
this some time ago, but it was rejected(lack of docs I think). Let me know if
it's of interest.

--
Andreas Joseph Krogh <andreak@officenet.no>
Senior Software Developer / Manager
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
------------------------+---------------------------------------------+
OfficeNet AS            | Two tomatoes in a fridge. One tomato says   |
Hoffsveien 17           | to the other, "It's cold in here, isn't it?"|
PO. Box 425 Skøyen      | The other tomato says, "F**king hell,       |
0213 Oslo               | a talking tomato!"                          |
NORWAY                  |                                             |
Phone : +47 22 13 01 00 |                                             |
Direct: +47 22 13 10 03 |                                             |
Mobile: +47 909  56 963 |                                             |
------------------------+---------------------------------------------+