Skip to content
Flow Like logo Flow Like Docs

Register PostgreSQL Node

Data/DataFusion/Databases

Register PostgreSQL

Register a PostgreSQL table for federated queries. Uses real database connection for full SQL push-down.

df_register_postgresdata
Inputs12
Outputs3
Security exposure4/10
Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

SecurityAttack surface and exposure impact.
4/10Medium
PrivacyPotential sensitivity of processed data.
5/10Medium
PerformanceRuntime or resource pressure.
3/10High
GovernancePolicy, audit, or compliance impact.
3/10High
ReliabilityOperational stability considerations.
2/10High
CostExternal or compute cost impact.
3/10High

Input Pins

12

Input

Execution
exec_in

Trigger execution

Session

Struct
session

DataFusion session

DataFusionSessionDataFusionSession1 fields
cache_keystringrequired

Host

String
host

PostgreSQL server host

Default localhost

Port

Integer
port

PostgreSQL server port

Default 5432

Database

String
database

Database name

Username

String
username

Database username

Password

String
password

Database password

Schema

String
schema

PostgreSQL schema

Default public

Source Table

String
source_table

Name of the table in PostgreSQL

Table Name

String
table_name

Name to register in DataFusion

SSL Mode

String
ssl_mode

SSL mode: disable, prefer, require, verify-ca, verify-full

Default prefer

Read Only

Boolean
readonly

Open connection in read-only mode

Default true

Output Pins

3

Done

Execution
exec_out

Table registered

Session

Struct
session_out

DataFusion session

DataFusionSessionDataFusionSession1 fields
cache_keystringrequired

Connection URL

String
connection_url

Generated connection URL (without password)

Node Info

Internal name
df_register_postgres
Category
Data/DataFusion/Databases