Re: Refer to another database

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