KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a string with value 'MAX DATE QUERY: SELECT iso_timestamp(MAX(time_stamp)) AS MAXTIME FROM observation WHERE offering_id = 'HOBART'' But on inserting into postgresql table i am getting error: org.postgresql.util.PSQLException: ERROR: syntax error at or near "HOBART". This is probably because my string contains single quotes. I don't know my string value. Every time it keeps changing and may contain special characters like \ or something since I am reading from a file and saving into postgres database. Please give a general solution to escape such characters.
Tags (comma-separated)
Save Edits
Cancel