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).