PostgreSQL Export

Export data to a PostgreSQL database.

Properties

NameType
engineString=postgres:export
connectionObject
tableString
schemaObject

engine

Must be postgres:export.

Required
Yes

connection

The SQL connection parameters.

Required
Yes

Properties

NameType
hostString
databaseString
userString
passwordString

connection.host

The network address of PostgreSQL e.g. `db.example.com:5432`.

Required
Yes

connection.database

The name of the PostgreSQL database.

Required
Yes

connection.user

The username to authenticate to PostgreSQL.

Required
Yes

connection.password

The password to authenticate to PostgreSQL. Requires `username`.

Required
Yes

table

The name of the PostgreSQL table.

Required
Yes

schema

Define a schema for the data.

Required
Yes