CODEWITHSUNDEEP
postgresqlescaping
user2490003
user2490003

Reputation: 11890

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

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!

Upvotes: 4

Views: 2688

Answers (1)

Juan Carlos Oropeza
Juan Carlos Oropeza

Reputation: 48197

use double quote:

 select "confirmed?" from user_purchases;

DEMO

Upvotes: 5

Related Questions