sql语句错误:“列..不存在"

问题描述

我正在从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语句错误:“列..不存在"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！