Embulk output plugin for PostgreSQL json column
This Embulk output plugin writes records to a json column of a table.
This works as following:
- transaction begin: creates a temporary table
- run: insert records to the temporary table
- 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