Possible to have multiple DB Aliases?

Question

We use two different iterations of PostgreSQL DB 9.3 on two different machines. I can create a DB Alias OK using sdbc : DSN=PostgreSQL35W, but if I want to access the other database, I have to re-configure this alias with credentials for the other DB. This results in lots of back and forth, and it's actually hard to tell exactly which DB we're currently accessing. If I create a new Alias, it just overwrites the other.

Is it possible to have more than one Alias for Postgres?

Thanks

dataMack · Accepted Answer

You can alias each odbc DSN once, so simply create a second odbc connection for your other machine and alias that.  This could also work for different database instances on the same machine.