pg_insert
Insert one or more rows into a PostgreSQL table and return the inserted rows.
Instructions
Insert one or more rows into a table. Returns inserted rows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name | |
| schema | No | Schema name (default: 'public') | |
| target | Yes | Target name from ~/.dbx/targets/ | |
| values | Yes | JSON array of values to insert (matches column order) | |
| columns | Yes | JSON array of column names |