pg_import_table_data
Transfer data from JSON or CSV files directly into PostgreSQL tables, enabling efficient table updates with optional truncation for clean imports.
Instructions
Import data from JSON or CSV file into a table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | ||
| delimiter | No | ||
| format | No | json | |
| inputPath | Yes | absolute path to the file to import | |
| tableName | Yes | ||
| truncateFirst | No |