What are string constants in PostgreSQL?
In PostgreSQL, a string constant is an arbitrary sequence of multiple characters that are bounded by single quotes (').
BY Best Interview Question ON 21 Jul 2020
Example
SELECT 'This' 'is' 'an' 'example'
Is equivalent to
SELECT 'This is an example'
Note that this is not the same as using double quotes (").