postgresql 大小写，别名

select ask.id "id",ask.createTime "createTime",ask.publisherID "publisherID",users.nickname "nickname",
users.icon "icon",users.gender "gender",ask.reward "reward",ask.zan "zan",ask.commentID "commentID",
ask.typee "type",ask.label "label",ask.content "content",ask.image "image",count(comment.id) "commentCount"
from ask inner join users on ask.publisherID=users.id 
left outer join comment on comment.objectID = ask.id 
group by ask.id,users.nickname,users.icon,users.gender
order by "createTime" desc
limit 10 offset 0;

postgresql默认全部小写，若要区分字段名大小写需要用引号括住

转载于:https://www.cnblogs.com/cdyboke/p/7160192.html