DB alias ?

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: DB alias ?
Date: 2013-01-23 20:45:53
Message-ID: 0AD01C53605506449BA127FB8B99E5E16112D00C@FMSMSX105.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Problem: Some users (scripts actually) try to connect to a DB who's name is derived from environmental variables. The DB doesn't exist (yet), and I want them to connect to a different DB for the time being. Is there a way to define an alias for the existing DB that = the db name that doesn't exist? Or is there a way to have PG fail over to a default DB should a DB connect fail? I can implement the fail over outside PG, but those users who make a direct connect to the DB don't use that code.

Thanks in Advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2013-01-23 20:54:21 Re: DB alias ?
Previous Message Andrew Dunstan 2013-01-23 18:19:33 Re: BUG #6510: A simple prompt is displayed using wrong charset