sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.05k stars 983 forks source link

Support for PostgreSQL COPY Command in ProxySQL #4746

Open rahim-kanji opened 2 weeks ago

rahim-kanji commented 2 weeks ago

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)

Planned Support for COPY FROM (Data Import)

Task List