Re: Refer to another database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Kalsch <andreaskalsch(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Refer to another database
Date: 2009-08-04 05:27:49
Message-ID: 15428.1249363669@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas Kalsch <andreaskalsch(at)gmx(dot)de> writes:
> This is what I want to do: To refer to another database, like I can do
> it in MySQL.

You're too hung up on the word "database". MySQL "databases" are very
nearly equivalent to Postgres schemas. Use multiple schemas within
one Postgres database and be happy.

> - I have to reset the search_path very often. This is probably not very
> elegant, but will be my solution then ...

And in MySQL you do "use foo" often. What's the difference?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kalsch 2009-08-04 05:43:17 Re: Refer to another database
Previous Message Andreas Kalsch 2009-08-04 05:18:39 Re: Refer to another database