select p.name as Name from person p;
as后的Name会显示为name，若想不忽略大小写，请把Name加上双引号
select p.name as "Name" from person p;
PostgreSQL AS不忽略大小写
原文：http://www.cnblogs.com/drizzlewithwind/p/5865662.html
