On Thu, Aug 21, 2008 at 3:32 PM, Olaf Frączyk <olaf@cbk.poznan.pl> wrote:
> Hello,
>
> When I define a new connection to a server I can enter
> host,port,username etc.
>
> I want to be able to define "search_path" to work with different
> schemas. I don't wan't to create a dozen of login roles with different
> search_path setting.
>
> The simplest solution would be to be able to define such variables at
> "Object browser" level. Then I could create several connections to my
> server with different search_path settings.
>
> However there is no way to do it nor to add an SQL statement to be
> executed at the beginning of every connection.
>
> There are other useful settings that could be managed this way.
>
> Is there any hope that it will be implemented in some future version?
What do you expect it to accomplish? As a graphical tool, pgAdmin
steps neatly round the vast majority of search path issues in the user
interface. It's only when you start using the query tool that you
might want to tweak the search path (and in that case, just store the
required SET query as a macro, and run it as needed.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com