pandas-to-postgres

pandas-to-postgres copied to clipboard

- SQL functionality updates - Parquet copying

bleonard33

Support for partitioned tables with inherited constraints

1

In a particular use case, I would like to use this library to COPY data into a child partition of a table. Primary key is defined on the parent table...

jeenut27

If there is a problem in the COPY stage - for example when there is a mismatch between the table and the DataFrame column names, the code gives an error...

jeenut27

No option to append to tables instead of truncating them

7

Thanks for the project it helps with the slow process for Dataframe `to_sql` and it's more straight to proceed with odoo or others library. For now i have an issue...

ziedbouf

Added `DataFrameCopyAppend` that appends data to table instead of overwriting it. Based on code in issue #8

licht1stein

We `DROP CASCADE` PKs, so later tables that had their FKs dropped in the cascade don't have `self.fks` instantiated (specifically if created with `defer_sql_obs=True`) because they have already been dropped.

bleonard33