batch insert/update
От
blackwater dev
Тема
batch insert/update
Дата
Msg-id
34a9824e0712261057v79de9c14ncc032fa43417252d@mail.gmail.com
Список
Дерево обсуждения
batch insert/update "blackwater dev" <blackwaterdev@gmail.com>
Re: batch insert/update Andreas Kretschmer <akretschmer@spamfence.net>
Re: batch insert/update Ivan Sergio Borgonovo <mail@webthatworks.it>
Re: batch insert/update Ivan Sergio Borgonovo <mail@webthatworks.it>
Re: batch insert/update Thomas Hart <tomhart@coopfed.org>
[TLM] Re: batch insert/update Ivan Sergio Borgonovo <mail@webthatworks.it>
Re: [TLM] Re: batch insert/update "blackwater dev" <blackwaterdev@gmail.com>
I have some php code that will be pulling in a file via ftp. This file will contain 20,000+ records that I then need to pump into the postgres db. These records will represent a subset of the records in a certain table. I basically need an efficient way to pump these rows into the table, replacing matching rows (based on id) already there and inserting ones that aren't. Sort of looping through the result and inserting or updating based on the presents of the row, what is the best way to handle this? This is something that will run nightly.
Thanks!
Thanks!
В списке pgsql-general по дате отправления