sql - Postgresql escape single quote in where clause -

so trying run script one:

select id owner  owner.name = "john's" 

and getting error: error: column "john's" not exist.

also tried this: where owner.name = 'john\'s', dit not work

anyone knows how can run query one?

you can escape single quotes when double them. example:

= 'john''s'