postgresql 大小寫，別名

標籤：大小寫   desc   image   font   select   icon   count   class   欄位名   

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.genderorder by "createTime" desclimit 10 offset 0;

postgresql預設全部小寫，若要區分欄位名大小寫需要用引號括住

postgresql 大小寫，別名