Re: Refer to another database - Mailing list pgsql-general

From Tom Lane
Subject Re: Refer to another database
Date
Msg-id 15428.1249363669@sss.pgh.pa.us
Whole thread Raw
In response to Re: Refer to another database  (Andreas Kalsch <andreaskalsch@gmx.de>)
Responses Re: Refer to another database  (Andreas Kalsch <andreaskalsch@gmx.de>)
List pgsql-general
Andreas Kalsch <andreaskalsch@gmx.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

pgsql-general by date:

Previous
From: Andreas Kalsch
Date:
Subject: Re: Refer to another database
Next
From: Andreas Kalsch
Date:
Subject: Re: Refer to another database