PostgreSQL output plugins for Embulk

PostgreSQL output plugins for Embulk loads records to PostgreSQL.

Overview

• Plugin type: output
• Load all or nothing: depnds on the mode:
  • insert: no
  • replace: yes
• Resume supported: no

Configuration

• host: database host name (string, required)
• port: database port number (integer, default: 5432)
• user: database login user name (string, required)
• password: database login password (string, default: "")
• database: destination database name (string, required)
• schema: destination schema name (string, default: "public")
• table: destination table name (string, required)
• mode: "replace" or "insert" (string, required)
• batch_size: size of a single batch insert (integer, default: 16777216)
• options: extra connection properties (hash, default: {})

Example

out:
  type: postgresql
  host: localhost
  user: pg
  password: ""
  database: my_database
  table: my_table
  mode: insert

Build

$ ./gradlew gem