下面是我的样本选择

 select thename from tblname

    thename
   -------------
   cash in hands
   round offs
   bank charges

那么,在上述选择中,如何将所有首字母转换为大写?
  select some_postgres_function from tblname

     thename
   -------------
   Cash In Hands
   Round Offs
   Bank Charges

最佳答案

一些u postgres函数initcap

 select initcap(thename) from tblname

String Functions and Operators

09-04 09:08