pg_copy_between_databases
Transfer data between PostgreSQL databases by specifying source and target connection strings and table name. Optionally truncate target table or filter data using a WHERE clause.
Instructions
Copy data between two databases
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sourceConnectionString | Yes | ||
| tableName | Yes | ||
| targetConnectionString | Yes | ||
| truncateTarget | No | ||
| where | No |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"sourceConnectionString": {
"type": "string"
},
"tableName": {
"type": "string"
},
"targetConnectionString": {
"type": "string"
},
"truncateTarget": {
"default": false,
"type": "boolean"
},
"where": {
"type": "string"
}
},
"required": [
"sourceConnectionString",
"targetConnectionString",
"tableName"
],
"type": "object"
}