Re: Refer to another database

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(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
>
>