String literals in PostgreSQL are defined by surrounding the content with
the '
character. For string literals that contain the '
character, you
may have seen it escaped with a preceding '
.
> select 'Isn''t this nice?';
?column?
------------------
Isn't this nice?
This is easy enough to do, but can be error prone and doesn't work well if SQL is being programmatically generated. A great workaround is to escape string literals using what is called dollar quoting.
> select $$Isn't this even nicer?$$;
?column?
------------------------
Isn't this even nicer?
Just wrap both ends in $$
instead of '
.