Giving a database an alias in postgres
You cannot create an alias to a schema or database since the Schemaname / DBname is used internally as primary key for the tables pg_namespace
and pg_database
.
The best solution seems to be PgBouncer. It allows you to pool and "redirect" connections from one database to another (even on a different host).