NodesDatabase Nodes
Edit Page on GitHubPostgreSQL - Insert Row(s)
Inserts one or more rows into a PostgreSQL table.
postgresdatabaseinsertwriteHard5
Description
PostgreSQL - Insert Row(s) node allows you to insert one or more rows into a specified PostgreSQL table using the provided connection details.
Common Use Cases
- Storing user data collected from an AI agent interaction
- Logging events or actions performed by an AI agent
- Maintaining a history of AI agent decisions or outputs
Inputs
The input connections this node accepts:
NameDescriptionTypeFlowThe flow of the workflowFlowTableName of the table to insert intoTextDataA JSON object or an array of JSON objects to insertJSON[]ReturningOptional. Columns to return after insertion (e.g., 'id' or '*')TextOutputs
The output connections this node provides:
NameDescriptionTyperowsThe data from the inserted rows, if 'Returning' is usedJSONrowCountThe number of rows that were successfully insertedNumberToolThe tool version of this node, to be used by LLMsToolFields
The configurable fields this node provides:
NameDescriptionTypeTableName of the table to insert intoValue:logsTextDataA JSON object or an array of JSON objects to insertValue: [{"level": "info", "message": "process started"}]JSON[]ReturningOptional. Columns to return after insertion (e.g., 'id' or '*')Value: *TextPG_CONNECTION_STRINGPostgres connection stringDefaultValue: postgres://user:password@localhost:5432/dbnameenvLast updated on