Two causes:
1) I have to rewrite many lines of code = time
2) In MySQL I have access - with superuser rights - to _all_ existing
databases inside the installation. In Postgres I haven't.
But, of course, that are just details.
Best,
Andi
Tom Lane schrieb:
> 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
>
>