Re: Database schemas: search_path

From: "Igor Maciel Macaubas" <igor(at)providerst(dot)com(dot)br>
To: "Jaime Casanova" <systemguards(at)yahoo(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Database schemas: search_path
Date: 2004-10-14 18:32:33
Message-ID: 001601c4b21c$2fdd09a0$6801a8c0@providerst.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Thanks, I did it using alter database and worked fine.
Thanks for all!

Regards,
Igor
--
igor(at)providerst(dot)com(dot)br

----- Original Message -----
From: "Jaime Casanova" <systemguards(at)yahoo(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Sent: Thursday, October 14, 2004 1:19 PM
Subject: Re: [ADMIN] Database schemas: search_path

> --- Bruno Wolff III <bruno(at)wolff(dot)to> escribió:
>> On Thu, Oct 14, 2004 at 09:42:45 -0300,
>> Igor Maciel Macaubas <igor(at)providerst(dot)com(dot)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

Browse pgsql-admin by date

  From Date Subject
Next Message CHRIS HOOVER 2004-10-14 19:46:00 Re: PostgreSQL Tool?
Previous Message Michael Long 2004-10-14 18:11:59 Re: PostgreSQL Tool?