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