How to use ESCAPE Clause In SQL

How to Insert a Value That Contains an Apostrophe?

When inserting a value with an apostrophe for example (“It’s raining”) in PostgreSQL It interprets the apostrophe as the end of the string which leads to syntax errors. To overcome this, we can use different methods to handle apostrophes. Below are the approaches are as follows:...

1. Using Double Apostrophe

Example: Let’s Insert a record into the “employee” table with ID 5 and name “Mr’s Aruna” also ensuring that the apostrophe in the name is escaped to avoid syntax errors....

2. Using Dollar Quoted Strings

Example: Let’s insert a record into the “employee” table with ID 6 and name “Mr’s Archana” using dollar-quoted strings, as we can saw the following query:...

3. Using ESCAPE Clause

Example: Let’s insert a record into the “employee” table with ID 6 and name “Mr’s Johnson“, as we can saw the following query....

Conclusion

Overall after reading whole article now you have clear understanding of how to insert values with apostrophes can be done using double apostrophes, escape characters or dollar-quoted strings in PostgreSQL. Each method provides a way to handle apostrophes and ensures the correct insertion of data containing them. Similarly these escape sequences are also used in many programming languages such as C , Python, Java etc....