insert_rows
Insert multiple rows into a PostgreSQL table in one batch operation. Use for bulk data insertion where all rows share the same column structure.
Instructions
Insert multiple rows into a PostgreSQL table in one batch.
Use this tool for bulk inserts where every row has the same columns.
table_name: table target, optionally schema-qualifiedrows: list of objects mapping column names to valuesreturning_columns: optional list of columns to return from inserted rows
Notes:
Every row must use the same columns in the same order.
Arrays can be passed as JSON lists and psycopg adapts them automatically.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | Yes | ||
| rows | Yes | ||
| returning_columns | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||