Re: Determining current database programmatically - Mailing list pgsql-general

From Doug McNaught
Subject Re: Determining current database programmatically
Date
Msg-id m3y9kkfdr1.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Determining current database programmatically  (Fran Fabrizio <ffabrizio@mmrd.com>)
List pgsql-general
Fran Fabrizio <ffabrizio@mmrd.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

pgsql-general by date:

Previous
From: "Campano, Troy"
Date:
Subject: Should I use CAST?
Next
From: Tom Lane
Date:
Subject: Re: Should I use CAST?