
Example:
dbadmin=> SELECT 'You''ll have to use '''' ''every'' time you want to display a '' in a ''Single-Quoted'' string literal!' "Confusing Syntax";
Confusing Syntax
---------------------------------------------------------------------------------
You'll have to use '' 'every' time you want to display a ' in a 'Single-Quoted' string literal!
(1 row)
dbadmin=> SELECT $$You don't have to use '' 'every' time you want to display a ' in a 'Dollar-Quoted' string literal!$$ "Not Confusing Syntax";
Not Confusing Syntax
------------------------------------------------------------------------------------
You don't have to use '' 'every' time you want to display a ' in a 'Dollar-Quoted' string literal!
(1 row)
Helpful Link:https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/SQLReferenceManual/LanguageElements/Literals/Dollar-quotedStringLiterals.htm
Have fun!