I am working with Python (psycopg). I have HTML with embedded Python that I'm
inserting into a database and it could contain any character.
Single quotes, at least, must be escaped (to two single quotes, right?) before
inserting it into Postgres.
This poses a problem when I get the data out of the table. It could have
originally contained two single quotes together and I replace them with one
single quote in the unescaping process.
How do you properly escape the special characters (and what all are they)?
TIA,
Scott