Re: Determining current database programmatically

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Determining current database programmatically
Дата
Msg-id m3y9kkfdr1.fsf@belphigor.mcnaught.org
обсуждение исходный текст
Ответ на Determining current database programmatically  (Fran Fabrizio <ffabrizio@mmrd.com>)
Список 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 по дате отправления:

Предыдущее
От: "Campano, Troy"
Дата:
Сообщение: Should I use CAST?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Should I use CAST?