Skip site navigation (1) Skip section navigation (2)

Search path in connection string

From: Julien Demoor <jdemoor(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Search path in connection string
Date: 2012-07-30 12:55:56
Message-ID: CANE6ZrC-9KDdWgFbBF7jLChbiE7PtFfn2FcGoPyTRxGOj_C9Eg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
There have been a number of messages on this list suggesting that the
Postgres JDBC driver should support setting the search path as part of the
connection string.

Can this be considered?

I have a use case where there doesn't appear to be any good alternatives:
using BIRT, with multiple clients sharing a Postgres database with one
schema each, one cannot just execute a SET SCHEMA statement (UPDATE
pg_settings ... is not possible either) and qualifying object names is also
not always possible (say, if there are stored procedures involved that use
unqualified object names).

Besides being useful in this case and surely others, this feature makes
sense: schemas can be used to offer separation of database objects very
similar to that offered by having multiple databases, and the database
itself is part of the connection string.

The patch proposed in
http://postgresql.1045698.n5.nabble.com/Patch-to-allow-setting-schema-search-path-in-the-connectionURL-td2174512.htmlis
still applicable.

Regards,
Julien

Responses

pgsql-jdbc by date

Next:From: Radim KolarDate: 2012-07-30 14:00:16
Subject: Re: not fetching all query results
Previous:From: Radim KolarDate: 2012-07-29 13:55:42
Subject: Re: not fetching all query results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group