Skip to main content
Version: 0.3.0

PostgresLoader

Input type: Table

Output type: None

Description​

Loads a Table into a PostgreSQL database sink.

Example 1​

 block CarsLoader oftype PostgresLoader {
   host: "localhost";
   port: 5432;
   username: "postgres";
   password: "postgres";
   database: "CarsDB";
   table: "Cars";
 }

A local Postgres instance is filled with table data about cars.

Properties​

host​

Type text

Description​

The hostname or IP address of the Postgres database.

port​

Type integer

Description​

The port of the Postgres database.

username​

Type text

Description​

The username to login to the Postgres database.

password​

Type text

Description​

The password to login to the Postgres database.

database​

Type text

Description​

The database to use.

table​

Type text

Description​

The name of the table to write into.