Forum OpenACS Q&A: Response to how to quote a double quote in Postgres inserts...

There shouldn't be a problem with double quotes. I insert text with double quotes all the time. Any string inside of single quotes should go into the database fine. LIke this:

INSERT INTO FOO '$QQvaluename'

Notice that the variable is inside of single quotes.