Thread: please help - schema in jdbc connection string

please help - schema in jdbc connection string

From
"Nanu Ram"
Date:

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

- Nanu

Re: please help - schema in jdbc connection string

From
Paul Thomas
Date:
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.
--
Paul Thomas
+------------------------------+-------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business           |
| Computer Consultants         | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+-------------------------------------------+

Re: please help - schema in jdbc connection string

From
Andreas Joseph Krogh
Date:
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 |                                             |
------------------------+---------------------------------------------+


Attachment

Re: please help - schema in jdbc connection string

From
Tom Lane
Date:
Andreas Joseph Krogh <andreak@officenet.no> writes:
> I don't think that's the answer hi's looking for. What he needs is setting =
> the=20
> default search_path to <schema> before he can operate on the db, and he=20
> doesn't want to do it programmaticly(which I understand why).

Possibly it would work to set his desired search path as a per-user
option (see ALTER USER).

            regards, tom lane

Re: please help - schema in jdbc connection string

From
"Nanu Ram"
Date:
I can definitely make use of this - or some other way to achieve this - I don't want to be required to specify the
schemain each of my sql statements. 

I heard someone say you can do it with the search path env. var. Can someone give an eg. of this in conjunction with a
javacode snippet? 

Thanks

NANU RAMAMRUTHAM / DIRECTOR, PRODUCT DEVELOPMENT /
nanu@icrossing.com

/direct/ 480.505.5810
/main/ 480.505.5800
/fax/ 480.505.5814

icrossing, inc.
icrossing.com | new york | scottsdale


-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Andreas Joseph Krogh
Sent: Wednesday, September 08, 2004 2:30 AM
To: Paul Thomas
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] 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 |                                             |
------------------------+---------------------------------------------+


Re: please help - schema in jdbc connection string

From
"Antony Paul"
Date:
http://www.postgresql.org/docs/7.3/static/ddl-schemas.html

rgds
Antony Paul

----- Original Message -----
From: "Nanu Ram" <nanu@icrossing.com>
To: "Andreas Joseph Krogh" <andreak@officenet.no>; "Paul Thomas"
<paul@tmsl.demon.co.uk>
Cc: <pgsql-jdbc@postgresql.org>
Sent: Wednesday, September 08, 2004 8:48 PM
Subject: Re: [JDBC] please help - schema in jdbc connection string


I can definitely make use of this - or some other way to achieve this - I
don't want to be required to specify the schema in each of my sql
statements.

I heard someone say you can do it with the search path env. var. Can someone
give an eg. of this in conjunction with a java code snippet?

Thanks

NANU RAMAMRUTHAM / DIRECTOR, PRODUCT DEVELOPMENT /
nanu@icrossing.com

/direct/ 480.505.5810
/main/ 480.505.5800
/fax/ 480.505.5814

icrossing, inc.
icrossing.com | new york | scottsdale


-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Andreas Joseph Krogh
Sent: Wednesday, September 08, 2004 2:30 AM
To: Paul Thomas
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] 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 |                                             |
------------------------+---------------------------------------------+


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly