--- 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
