我继承了一个Postgres数据库中的一列,它的名称中有一个问号。
当我尝试选择它时,会抛出一个错误。
> 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?".
我也尝试使用反引号(`confirmed?`)和引号("confirmed?")选择它,但是仍然出现相同的错误。
如何选择此字段?
谢谢!
select up."confirmed?" from user_purchases up
。 - user2490003