这篇文章主要介绍了postgresql查询自动将大写的名称转换为小写的案例，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧
我就废话不多说了，大家还是直接看代码吧~
SELECT sum(aa) as "recordNumber" FROM table
SELECT sum(aa) as recordNumber FROM table
postgis查询字段是将字段字段转为小写，如果需要大写的字符，需要加双引号
补充：Postgresql中表名、列名、用户名大小写问题
注意：是双引号，单引号可能会被解析成普通字符，因而是不识别的字段
highgo=# create table "ExChange" (id int);
CREATE TABLE
highgo=# create table ExChange (id int);
CREATE TABLE
highgo=# \d
List of relations
Schema | Name | Type | Owner
—————-+———-+——-+——–
oracle_catalog | dual | view | highgo
public | ExChange | table | highgo
public | exchange | table | highgo
public | myt | table | highgo
public | t1 | table | highgo
public | tran | table | highgo
(6 rows)
highgo=# insert into exchange values (1);
INSERT 0 1
highgo=# insert into "ExChange" values (2);
INSERT 0 1
highgo=# select * FROM exchange ;
id
—-
1
(1 row)
highgo=# select * FROM ExChange ;
id
—-
1
(1 row)
highgo=# select * FROM "ExChange" ;
id
—-
2
(1 row)
highgo=# insert into ExChange values (2);
INSERT 0 1
highgo=# select * FROM "ExChange" ;
id
—-
2
(1 row)
highgo=# select * FROM exchange ;
id
—-
1
2
(2 rows)
