From: Bruno Wolff III <bruno@wolff.to>
To: Igor Maciel Macaubas <igor@providerst.com.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database schemas: search_path
Date: Thu, 14 Oct 2004 09:34:32 -0500
Message-ID: <20041014143432.GA25803@wolff.to> (raw)
In-Reply-To: <001601c4b1eb$50f45fc0$6801a8c0@providerst.local>
References: <001601c4b1eb$50f45fc0$6801a8c0@providerst.local>
On Thu, Oct 14, 2004 at 09:42:45 -0300,
Igor Maciel Macaubas <igor@providerst.com.br> wrote:
> Hi all,
>
> I've organized my database design in multiple schemas, and migrated my existing tables to different schemas by using a simple how-to I found in this list history.
> But what I couldn't find was a way to make this schemata fully transparent to my application - which does selects directly to tables instead to schema.table. I know that I can always set the search_path environmnet variable, but I have to do it on each session. I'd like to know if there is a way to make my set search_path persistent on the database, no matter the session.
> I believe that this is supported, but couldn't find out how to make it. Can someone help me?
Use ALTER DATABASE to set per database defaults.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruno@wolff.to, igor@providerst.com.br
Subject: Re: Database schemas: search_path
In-Reply-To: <20041014143432.GA25803@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox