pg_export_table_data
Export PostgreSQL table data to JSON or CSV for analysis or migration. Specify table name, output path, and optional filters like 'where' clause or row limit to customize data extraction.
Instructions
Export table data to JSON or CSV format
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | ||
| format | No | json | |
| limit | No | ||
| outputPath | Yes | absolute path to save the exported data | |
| tableName | Yes | ||
| where | No |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"connectionString": {
"type": "string"
},
"format": {
"default": "json",
"enum": [
"json",
"csv"
],
"type": "string"
},
"limit": {
"exclusiveMinimum": 0,
"type": "integer"
},
"outputPath": {
"description": "absolute path to save the exported data",
"type": "string"
},
"tableName": {
"type": "string"
},
"where": {
"type": "string"
}
},
"required": [
"tableName",
"outputPath"
],
"type": "object"
}