Re: Determining current database programmatically

From: Doug McNaught <doug(at)wireboard(dot)com>
To: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Determining current database programmatically
Date: 2001-12-03 16:51:46
Message-ID: m3y9kkfdr1.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fran Fabrizio <ffabrizio(at)mmrd(dot)com> writes:

> One alternative I can think of is to have a column in the databases
> that list the email address that the message should go to, but this
> means that I would no longer be able to use the same data loading
> scripts on both databases like I can do now. I can do it this way
> if necessary but I was looking for something a little more dynamic.

Really, I'd go ahead and do the above. It means you can change/add
email addresses easily without bringing the system down. As for
loading, you could add an argument to the load script controlling
which set of addresses gets added, eg:

$ ./loaddata dev

$ ./loaddata prod

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2001-12-03 17:01:45 Re: interval
Previous Message Campano, Troy 2001-12-03 16:22:23 Should I use CAST?