import-from-postgres

Description

import-from-postgres adaptor imports data from a PostgreSQL database

Inputs

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

port Type: number Required: No The port of the database server. If unspecified, defaults to 5432.

database Type: text Required: Yes The name of the database.

username Type: text Required: No The username to connect to the database.

password Type: text Required: No The password to connect to the database.

query Type: text Required: Yes The SQL query reading from the database (e.g. SELECT * from table WHERE ...).

Outputs

data Type: datatable A datatable containing the imported data.

Examples

Example 1: Default behaviour.

Inputs:

hostname: localhost

port: 5444

database: demoDB

username: demo_user

password: demo_password

query:

SELECT 1 AS field1, 'a' AS field2
UNION
SELECT 2 AS field1, 'b' AS field2
UNION
SELECT 3 AS field1, 'c' AS field2

Outputs:

data:

field1	field2
1	a
2	b
3	c

-> Imported data from PostgreSQL database into Data-flo.