Hi,
Thanks, I did it using alter database and worked fine. Thanks for all!
Regards, Igor -- [EMAIL PROTECTED]
----- Original Message ----- From: "Jaime Casanova" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 14, 2004 1:19 PM
Subject: Re: [ADMIN] Database schemas: search_path
--- Bruno Wolff III <[EMAIL PROTECTED]> escribió:On Thu, Oct 14, 2004 at 09:42:45 -0300, Igor Maciel Macaubas <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match