PostgresOSM.psql_insert_copy

static PostgresOSM.psql_insert_copy(sql_table, sql_db_engine, column_name_list, 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_name_list – (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 [SQL-P-PIC-1].