Postgres - Escaping a Question Mark (?) in a column name

Question

One of the columns in a Postgres DB I inherited has a question mark in the name.

When I try to select it, it throws an error

> select confirmed? from user_purchases;

ERROR:  column "confirmed" does not exist
LINE 1: select confirmed? from user_purchases;
               ^
HINT:  Perhaps you meant to reference the column "user_purchases.confirmed?".

I've also tried selecting it with backticks (`confirmed?`) and quotes ("confirmed?") but the same error is raised.

How do I select this field?

Thanks!

Answer 1

use double quote:

 select "confirmed?" from user_purchases;

DEMO