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