postgress-database

Imports data from a PostgreSQL database.

This adaptor allows users to set up a connection to a database, set a query, and extract data from the database into a Data-flo datatable.

Arguments

Inputs:

hostname: The hostname (.e.g localhost) or the IP address (e.g. 127.0.0.1) of the database server.

port: The port of the database server. If unspecified, defaults to "5432".

database: The name of the database.

username: The username to connect to the database.

password: The password to connect to the database. TIP: when binding, consider treating the value as secret.

query: The SQL query reading from the database (e.g. "SELECT * from table WHERE ...").

Output:

data: The datatable containing the imported data.