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!

Juan Carlos Oropeza · Accepted Answer · 2018-02-02 18:52:50Z

5

use double quote:

 select "confirmed?" from user_purchases;

DEMO

answered Feb 2, 2018 at 18:52

Juan Carlos Oropeza

48.4k14 gold badges87 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2490003 Over a year ago

Thanks! So I had tried this and it didn't work, but I just realized that I was using a table alias, which I hadn't made clear in the original question. So for anyone else in the same situation using table aliases, it's select up."confirmed?" from user_purchases up.

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related