how to replace a table in pg Admin threw Jupyter Notebook? I used this script Class_yelp.to_postgis(“class_yelp4”, engine), it runs, but when I want to restart the kernel or run the all script from the beginning, here comes me the message, that “ValueError: Table ‘class_yelp4’ already exists.”
It is for me useful when we change one column in Jupyter ntb and wanted than to replace threw Jupyter ntb. How can I fix it? Thank you, I’m the beginner 🙂
I tried these varieties: Class_yelp.to_postgis(“class_yelp4”, engine, if exist = replace/append). Replace runs, but then PG admin shows no data in the table. Append put the data at the end of the existing table, so than I have doubled more rows.
Klara_gis_user is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.