pgsql 数据库表名大写

pgsql 严格区分大小写  但是 在使用jpa时 会默认将大写转化为小写  导致运行时报错，找不到这个类 这时需要加上转移字符

对于关键字也要加上转义字符

 

代码：

    @Query(value = "SELECT object_id, \"key\", \"value\" from \"prj_dio_alarm_cfg_mpActSeverityPairs\" where object_id in (:object_id)", nativeQuery = true)
    List<PrjDioAlarmCfgMpActSeverityPairs> findByObjectIdIn(@Param(value = "object_id") List<UUID> object_id);