pg_import_table_data
Transfer data from JSON or CSV files into a PostgreSQL table. Specify the table name, file path, and optional truncation, format, or delimiter settings for precise integration.
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 |