PostgreSQL AS不忽略大小写

select p.name as Name from person p;

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

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