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.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to