sql语句错误:“列..不存在" [英] sql statement error: "column .. does not exist"

问题描述

我正在从Postgres控制台尝试以下命令:

Im trying from postgres console this command:

select sim.id as idsim, 
       num.id as idnum 
from main_sim sim 
  left join main_number num on (FK_Numbers_id=num.id);

我得到了这个答复:

ERROR:  column "fk_numbers_id" does not exist
LINE 1: ...m from main_sim sim left join main_number num on (FK_Numbers...

但是如果我只是用以下方法检查表:

but if I simply check my table with:

dbMobile=# \d main_sim

 id              | integer               | not null default

 Iccid           | character varying(19) | not null

...

 FK_Device_id    | integer               | 

 FK_Numbers_id   | integer               | 

Indexes:
    "main_sim_pkey" PRIMARY KEY, btree (id)
    "main_sim_FK_Numbers_id_key" UNIQUE, btree ("FK_Numbers_id")
    "main_sim_Iccid_key" UNIQUE, btree ("Iccid")
    "main_sim_FK_Device_id" btree ("FK_Device_id")
Foreign-key constraints:
    "FK_Device_id_refs_id_480a73d1" FOREIGN KEY ("FK_Device_id") REFERENCES main_device(id) DEFERRABLE INITIALLY DEFERRED
    "FK_Numbers_id_refs_id_380cb036" FOREIGN KEY ("FK_Numbers_id") REFERENCES main_number(id) DEFERRABLE INITIALLY DEFERRED

...我们可以看到该列存在.

...as we can see the column exist.

可能是语法错误，但是我看不到什么...

probably it's syntax error, but I'm unable to see what...

任何帮助将不胜感激. 阿莱西奥

any help will'be appreciated. Alessio

推荐答案

否，列FK_Numbers_id不存在，仅列"FK_Numbers_id"存在

No, the column FK_Numbers_id does not exist, only a column "FK_Numbers_id" exists

显然，您使用双引号创建了表，因此，所有列名现在都区分大小写，并且必须始终使用双引号:

Apparently you created the table using double quotes and therefor all column names are now case-sensitive and you have to use double quotes all the time:

select sim.id as idsim, 
       num.id as idnum 
from main_sim sim 
   left join main_number num on ("FK_Numbers_id" = num.id);

回顾一下已记录的内容在手册中:

列foo和FOO相同，列"foo"和"FOO"不相同.

The column foo and FOO are identical, the columns "foo" and "FOO" are not.

这篇关于sql语句错误:“列..不存在"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！