Re: making postgresql "source" its data feed from external csv file ...

Поиск
Список
Период
Сортировка
От Maciek Sakrejda
Тема Re: making postgresql "source" its data feed from external csv file ...
Дата
Msg-id AANLkTikN5bHyCf6zvCJxcfiB28UC6P_w2zBdODCHLG32@mail.gmail.com
обсуждение исходный текст
Ответ на making postgresql "source" its data feed from external csv file ...  (Albretch Mueller <lbrtchx@gmail.com>)
Список pgsql-jdbc
If your tables are read-only (which it kind of sounds like), you could
abstract out the reload mechanism, use the current implementation for
the in-memory databases, and use a combination of watching the CSV
files (e.g., through inotify on Linux) and TRUNCATE / COPY in
PostgreSQL. I think how well this will work will really depend on what
you're doing with the system, but it could be worth a shot.
---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: making postgresql "source" its data feed from external csv file ...
Следующее
От: Albretch Mueller
Дата:
Сообщение: Re: making postgresql "source" its data feed from external csv file ...