No commit activity in last 3 years
No release in over 3 years
Embulk output for PostgreSQL json and jsonb column
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Development

~> 1.0
>= 0.9.2

Runtime

 Project Readme

Embulk output plugin for PostgreSQL json column

This Embulk output plugin writes records to a json column of a table.

This works as following:

  1. transaction begin: creates a temporary table
  2. run: insert records to the temporary table
  3. transaction commit: copy the records to the actual table and drop the temporary table

Overview

  • Plugin type: output
  • Load all or nothing: yes
  • Resume supported: no

Configuration

  • host host name of the PostgreSQL server (string, required)
  • port port of the PostgreSQL server (integer, default: 5432)
  • username login user name (string, required)
  • password login password (string, default: "")
  • database destination database name (string, required)
  • table destination table name (string, required)
  • column destination column name (string, default: "json")
  • column_type json or jsonb (string, default: 'json')

Example

out:
  type: postgres_json
  host: localhost
  port: 5432
  username: pg
  database: embulk_test
  table: load01