PostgreSQL.psql_insert_copy
- static PostgreSQL.psql_insert_copy(sql_table, sql_db_engine, column_names, data_iter)
A callable using PostgreSQL COPY clause for executing inserting data.
- Parameters
sql_table – pandas.io.sql.SQLTable
sql_db_engine – sqlalchemy.engine.Connection or sqlalchemy.engine.Engine
column_names – (list of str) column names
data_iter – iterable that iterates the values to be inserted
Note
This function is copied and slightly modified from the source code available at [DBMS-PS-PIC-1].