{"action":"created","issue":{"url":"https://api.github.com/repos/dimitri/pgloader/issues/280","labels_url":"https://api.github.com/repos/dimitri/pgloader/issues/280/labels{/name}","comments_url":"https://api.github.com/repos/dimitri/pgloader/issues/280/comments","events_url":"https://api.github.com/repos/dimitri/pgloader/issues/280/events","html_url":"https://github.com/dimitri/pgloader/issues/280","id":102595983,"number":280,"title":"Is there a way to make pgloader update an existing record?","user":{"login":"dzuluaga","id":1755383,"avatar_url":"https://avatars.githubusercontent.com/u/1755383?v=3","gravatar_id":"","url":"https://api.github.com/users/dzuluaga","html_url":"https://github.com/dzuluaga","followers_url":"https://api.github.com/users/dzuluaga/followers","following_url":"https://api.github.com/users/dzuluaga/following{/other_user}","gists_url":"https://api.github.com/users/dzuluaga/gists{/gist_id}","starred_url":"https://api.github.com/users/dzuluaga/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dzuluaga/subscriptions","organizations_url":"https://api.github.com/users/dzuluaga/orgs","repos_url":"https://api.github.com/users/dzuluaga/repos","events_url":"https://api.github.com/users/dzuluaga/events{/privacy}","received_events_url":"https://api.github.com/users/dzuluaga/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-23T07:29:40Z","updated_at":"2015-08-23T22:23:04Z","closed_at":"2015-08-23T22:23:04Z","body":"I want to leverage pgloader to import data into a table which already has data. So, if the primary key already exists, I want to update any of the existing values with the data coming in a CSV file. Is that possible?"},"comment":{"url":"https://api.github.com/repos/dimitri/pgloader/issues/comments/133947434","html_url":"https://github.com/dimitri/pgloader/issues/280#issuecomment-133947434","issue_url":"https://api.github.com/repos/dimitri/pgloader/issues/280","id":133947434,"user":{"login":"dimitri","id":102900,"avatar_url":"https://avatars.githubusercontent.com/u/102900?v=3","gravatar_id":"","url":"https://api.github.com/users/dimitri","html_url":"https://github.com/dimitri","followers_url":"https://api.github.com/users/dimitri/followers","following_url":"https://api.github.com/users/dimitri/following{/other_user}","gists_url":"https://api.github.com/users/dimitri/gists{/gist_id}","starred_url":"https://api.github.com/users/dimitri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dimitri/subscriptions","organizations_url":"https://api.github.com/users/dimitri/orgs","repos_url":"https://api.github.com/users/dimitri/repos","events_url":"https://api.github.com/users/dimitri/events{/privacy}","received_events_url":"https://api.github.com/users/dimitri/received_events","type":"User","site_admin":false},"created_at":"2015-08-23T22:23:04Z","updated_at":"2015-08-23T22:23:04Z","body":"It is not supported directly by pgloader, but what you can do is load into a work table then use the technique detailed in my blog at http://tapoueh.org/blog/2013/03/15-batch-update against that work table."}}