fix issue with psql and mixing single / double quotes

KaylaCrush / advocacy-maps

The good governance project (GGP) is a non-partisan democracy reform group.

https://mapletestimony.org

MIT License

0 stars 1 forks source link

fix issue with psql and mixing single / double quotes #55

Closed KaylaCrush closed 1 year ago

KaylaCrush commented 1 year ago

When saving tables in postgres we are hitting a problem with tables that contain apostrophes. It's wrapping cells that contain single quotes in double quotes, but also fucking up the formatting for all the other cells by putting escape characters (/) in front of every single quote. See url05[56], the Boston Police Potrolmen's Association, or url05[159], O'Niell and Associates

KaylaCrush commented 1 year ago

Fixed by correcting my psycopg2 execute statements