[2

PostgreSQL's "column does not exist" Error: A Case-Sensitivity Issue

即使列明确定义了，也是“不存在”的常见postgresql头痛是“不存在”错误。 这通常源于病例敏感性问题。考虑此示例：[

选择“大陆” 来自Network.countries 非洲大陆不是无效的 和大陆'' 限制5

SELECT Continent
FROM network.countries
WHERE Continent IS NOT NULL
AND Continent  ''
LIMIT 5

ERROR: column "continent" does not exist
Hint: Perhaps you meant to reference the column "countries.Continent".
Position: 8

通过double quoting “ controment” ，您明确地告诉PostgreSQL将名称视为案例敏感的文字字符串，防止误解。 [2