Re: Database schemas: search_path - Mailing list pgsql-admin

From Igor Maciel Macaubas
Subject Re: Database schemas: search_path
Date
Msg-id 001601c4b21c$2fdd09a0$6801a8c0@providerst.local
Whole thread Raw
In response to Re: Database schemas: search_path  (Jaime Casanova <systemguards@yahoo.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Michael Long
Date:
Subject: Re: PostgreSQL Tool?
Next
From: "CHRIS HOOVER"
Date:
Subject: Re: PostgreSQL Tool?