search

psqlpy-python / psqlpy

Asynchronous Python PostgreSQL driver written in Rust
https://psqlpy-python.github.io/
MIT License
211 stars 3 forks source link

Support "quoting" column names #71

Open xiaoxianma opened 2 months ago

xiaoxianma commented 2 months ago

When passing a "quoting" column name to binary_copy_to_table, psqlpy raises syntax error. Callers have to wrap those columns in a double quote by themselves. It would be great to support this in the library.

workaround,

async def main():
    res = await conn.binary_copy_to_table(
        columns=[
            '"a-b"',
        ],
        ...
    )