Support for PostgreSQL COPY Command in ProxySQL

[rahim-kanji]

Description

This feature request is for adding support for PostgreSQL’s COPY command in ProxySQL. The COPY command in PostgreSQL is used to transfer data to and from database tables, allowing high-performance data import and export operations.

Current Behavior

Currently, ProxySQL does not support PostgreSQL’s COPY command. Attempting to execute COPY commands will result in an "Unsupported feature" error.

Feature Scope

The feature will initially support COPY TO functionality, enabling data export from PostgreSQL tables to a file or standard output through ProxySQL. This implementation will allow for large, efficient data exports.

In a future update, support for COPY FROM will be added to allow data import into PostgreSQL tables through ProxySQL. This functionality is more complex to implement due to specific challenges with data input handling and may require modifications to ProxySQL’s handling of PostgreSQL commands.

Feature Requirements and Expected Functionality

Support for COPY TO (Data Export)

• Enable ProxySQL to handle PostgreSQL’s COPY TO command, allowing users to export data from PostgreSQL tables through ProxySQL.

Planned Support for COPY FROM (Data Import)

• In the future, ProxySQL will add support for COPY FROM to allow data imports.

Task List

• Implement support for COPY TO in ProxySQL for PostgreSQL.
• Add COPY FROM support in ProxySQL for PostgreSQL.