Escaping A Quote In A String
In PostgreSQL, string (
text) literals are declared with
single quotes (
'). That means that any string containing a single quote
will need some escaping. The way to escape a single quote is with another
> select 'what''s up!'; ?column? ------------ what's up!