Hello Rails community
I cannot seem to find via Google what I had hoped would be
a simple issue
On a single DB system (currently, postgres 8.1.4),
I have two databases, each containing multiple tables.
I would like to configure my app and database.yml to recognize
these two databases.
What is the corrrect config for the database.yml ?
Is it something like:
database: database1, database2
Is there some trick involved with this kind of configuration ?
Presumably, I would have open two db connections within
the app, as a result of which, dereferencing the db off of
these would uniquely identify the respective database and its
tables. But of course, I hope it would be ActiveRecord keeping
track of these distinctions.
But then, maybe this is not so, and it is necessary to fully qualify
the accesses to elements of the tables.
Anyhow, could someone please point me to info and examples
of this nature of access ?
Of course, doing this kind of thing in ruby itself is simple - I’ve
done this for simultaneous access to MySql and postgres, as in
when I transfered tables from the one to the other.