kobo-to-postgres.js

// Note that for Postgres you're mapping data from questions to specific columns

upsert('assessment_site', 'ON CONSTRAINT assessment_site_pkey', {
  study_id: 1000,
  site_id: 1001,
  admin_level_3: state.data.body['survey_info/district'],
  site_name: state.data.body['survey_info/village'],
  enumerator_name: state.data.body.surveyorName,
  date_of_submission: state.data.body.dateCaptured,
  // ...
});