java问题总结 pg库查询如何区分大小写-StringBuilder如何拼接双引号

1、在字段添加双引号，如不加双引号，默认读取小写dzbm

SELECT * FROM people pi left join build bu on pi."DZBM" = bu."dzbm"

2、StringBuilder如何拼接双引号

StringBuilder sql = new StringBuilder();
sql.append("\"").append("name").append("\"");
输出-- "name"

3、查询字段值中含单引号——将字段值中的单引号变成二个单引号

这样是可以查出来值的

SELECT * FROM people pi where pi."FWCS" = 'it''s tea 奶茶'

4、将pg库left join的表数据生成一张表

create table aa as SELECT * FROM people pi left join build bu on pi."DZBM" = bu."dzbm"