Create postgres table from pandas dataframe into specific schema

Question

I have two schema in PostgreSQL i.e public schema and Staging schema. Then from pandas dataframe I tried to create table in Staging schema, so I tried this method.

# establishing connection with database using sql alcemy
engine = create_engine('postgresql://postgres:root@localhost:5432/TestWarehouse')
sales_df_col.to_sql("Staging.tblsalesdata",engine)

Then instead of creating table in Staging schema, table name 'Staging.tblsaledata' was created in public schema. How can I create table 'tblsalesdata' into Staging schema from pandas?

Nitish · Accepted Answer · 2022-09-15 06:25:15Z

1

According to documentation: pandas.DataFrame.to_sql, you need to pass schema as a separate parameters.

Try:

sales_df_col.to_sql("tblsalesdata",engine, schema='Staging')

answered Sep 15, 2022 at 6:25

Nitish

4623 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create postgres table from pandas dataframe into specific schema

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related