Re: Refer to another database

From: Harald Fuchs <hari(dot)fuchs(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Refer to another database
Date: 2009-08-04 12:51:33
Message-ID: pumy6fkai2.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <4A77C4AF(dot)2060709(at)gmx(dot)de>,
Andreas Kalsch <andreaskalsch(at)gmx(dot)de> writes:

> To be completely
> in context of a schema - so that I can use all tables without the
> prefix - I have to reset the search_path very often.

Why? Just say "ALTER DATABASE foo SET search_path = public, bar, baz"
once and you're done.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kalsch 2009-08-04 13:02:28 Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"
Previous Message Paul Taylor 2009-08-04 12:37:34 Does derby have an embedded Mode like Derby ?