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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster