From: Igor Maciel Macaubas <igor@providerst.com.br>
To: Jaime Casanova <systemguards@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: Database schemas: search_path
Date: Thu, 14 Oct 2004 15:32:33 -0300
Message-ID: <001601c4b21c$2fdd09a0$6801a8c0@providerst.local> (raw)
References: <20041014161946.26948.qmail@web50006.mail.yahoo.com>
Hi,
Thanks, I did it using alter database and worked fine.
Thanks for all!
Regards,
Igor
--
igor@providerst.com.br
----- Original Message -----
From: "Jaime Casanova" <systemguards@yahoo.com>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, October 14, 2004 1:19 PM
Subject: Re: [ADMIN] Database schemas: search_path
> --- Bruno Wolff III <bruno@wolff.to> escribió:
>> 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.
>>
>
> Hi,
> set the parameter in the postgresql.conf
>
> Regards,
> Jaime Casanova
>
> _________________________________________________________
> Do You Yahoo!?
> Información de Estados Unidos y América Latina, en Yahoo! Noticias.
> Visítanos en http://noticias.espanol.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
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: igor@providerst.com.br, systemguards@yahoo.com
Subject: Re: Database schemas: search_path
In-Reply-To: <001601c4b21c$2fdd09a0$6801a8c0@providerst.local>
* 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