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
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? |