Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Shaozhong SHI <shishaozhong(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres
Date: 2021-10-04 16:06:40
Message-ID: a6105435-6bfd-8776-fe38-13ffab752f23@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On 10/4/21 8:44 AM, Shaozhong SHI wrote:
>
> Has anyone tested this one?
> A Fast Method to Bulk Insert a Pandas DataFrame into Postgres · Ellis
> Valentiner
> <https://ellisvalentiner.com/post/a-fast-method-to-insert-a-pandas-dataframe-into-postgres/>
>
> I tried psql_insert_copy method, but I got the following error message.
>
> to_sql() got an unexpected keyword argument 'method'
>
>
> Can anyone shed light on this?

method is a legitimate keyword:

https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_sql.html?highlight=to_sql#pandas.DataFrame.to_sql

So there must be something about how you used it.

Pandas version?

The actual code you used when the error occurred?

>
>
> Regards,
>
>
> David
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaozhong SHI 2021-10-04 16:20:42 Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres
Previous Message Shaozhong SHI 2021-10-04 15:44:28 Testing of a fast method to bulk insert a Pandas DataFrame into Postgres

Browse pgsql-sql by date

  From Date Subject
Next Message Shaozhong SHI 2021-10-04 16:20:42 Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres
Previous Message Shaozhong SHI 2021-10-04 15:44:28 Testing of a fast method to bulk insert a Pandas DataFrame into Postgres