Postgresql escapes single quotes in where where

Question

so I'm trying to run a script like this:

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

and I get this error: ERROR: column "john's" does not exist .

Also I tried like this: where owner.name = 'john\'s' , but it does not work

Does anyone know how I can run such a query?

Answer 1

You can avoid single quotes when you double them. For instance:

 = 'john''s' 

Answer 2

Try this

 select id from owner where owner.name = (E'john\'s')::text 

Update: we can avoid most characters using this statement

select the identifier from the owner, where owner.name = (E'john * Your character you want to escape * s') :: text