首页 > 代码库 > PostgreSQL AS不忽略大小写

PostgreSQL AS不忽略大小写

select p.name as Name from person p;

as后的Name会显示为name,若想不忽略大小写,请把Name加上双引号

select p.name as "Name" from person p;

 

PostgreSQL AS不忽略大小写