Debug笔记——python数据库连接查询报错

今天在用python连接数据库的时候遇到了“column_…_ does not exit”的问题，后来检查发现是因为sql数据库里面的字段是区分大小写的，而通过PostgreSQL进行查询时，不带引号的字段全部会自动转为小写，因而导致查询失败

(psycopg2.errors.UndefinedColumn) column “wellhead_coordinates_x” does not exist
LINE 7: wellhead_coordinates_X AS wellhead_x,
^
HINT: Perhaps you meant to reference the column “mud_logging_integrated_db_basic_data.wellhead_coordinates_X” or the column “mud_logging_integrated_db_basic_data.wellhead_coordinates_Y”.

[SQL:
SELECT
belong_to_name AS well_id,
kelly_bushing_height,
kelly_bushing_elevation,
ground_elevation,
wellhead_coordinates_X AS wellhead_x,
wellhead_coordinates_Y AS wellhead_y,
final_drilling_depth
FROM mud_logging_integrated_db_basic_data
]
e