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

Reply via email to