SQL · String functions

quote_literal()

Escapes a value for safe inclusion in SQL. PostgreSQL.

sqlRunnable example sql course

Syntax

quote_literal(text)

Example

Open in the lab

SELECT quote('it''s') AS quoted;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.