escape-single-quote.md

Escaping Single Quotes

According to the SQL standard escaping single quotes should be done with another single quote.

INSERT INTO mytable (name) VALUES ('Shaquille O''Neal')

Note: See the two single quotes in O''Neal

---

Refs

• PostgreSQL Docs - String Constants