org.springframework.jdbc.BadSqlGrammarException: Error querying database. Cause: org.postgresq

问题背景：使用MyBatisPlus查询PostgreSQL数据库数据信息报sql语法异常

将控制台报错的sql语句复制到dbeaver中执行

### SQL: SELECT  id,name,age,email,created_by,create_date,updated_by,update_date,deleted_by,delete_date,is_deleted  FROM user
### Cause: org.postgresql.util.PSQLException: ERROR: column "id" does not exist

dbeaver的sql脚本还是显示报错

查找user在哪，postgresql中表放在模式下面。

找到表放在mybatisplusdemo模式下后，将实体类打上@TableName(schema = "mybatisplusdemo", value = "user")注解，其中schema代表模式，value代表表名。

@Data
@TableName(schema = "mybatisplusdemo", value = "user")
public class User {
    // 指定主键生成策略为雪花算法
    @TableId(type = IdType.ASSIGN_ID)
    private Long id;

    private String name;

    private Integer age;

    private String email;

    private String createdBy;

    private Date createDate;

    private String updatedBy;

    private Date updateDate;

    private String deletedBy;

    private Date deleteDate;

    private Boolean isDeleted;
}

执行测试代码

    @Test
    public void testSelect() {
        System.out.println("------ selectAll method test ------");
        List<User> users = userMapper.selectList(null);
        Assert.assertEquals(5, users.size());
        users.forEach(System.out::println);
    }

执行结果

User(id=1, name=Jone, age=18, email=test1@baomidou.com, createdBy=wcx, createDate=Fri May 26 17:28:47 CST 2023, updatedBy=wcx, updateDate=Fri May 26 17:28:47 CST 2023, deletedBy=null, deleteDate=null, isDeleted=false)
User(id=2, name=Jack, age=20, email=test2@baomidou.com, createdBy=wcx, createDate=Fri May 26 17:28:47 CST 2023, updatedBy=wcx, updateDate=Fri May 26 17:28:47 CST 2023, deletedBy=null, deleteDate=null, isDeleted=false)
User(id=3, name=Tom, age=28, email=test3@baomidou.com, createdBy=wcx, createDate=Fri May 26 17:28:47 CST 2023, updatedBy=wcx, updateDate=Fri May 26 17:28:47 CST 2023, deletedBy=null, deleteDate=null, isDeleted=false)
User(id=4, name=Sandy, age=21, email=test4@baomidou.com, createdBy=wcx, createDate=Fri May 26 17:28:47 CST 2023, updatedBy=wcx, updateDate=Fri May 26 17:28:47 CST 2023, deletedBy=null, deleteDate=null, isDeleted=false)
User(id=5, name=Billie, age=24, email=test5@baomidou.com, createdBy=wcx, createDate=Fri May 26 17:28:47 CST 2023, updatedBy=wcx, updateDate=Fri May 26 17:28:47 CST 2023, deletedBy=null, deleteDate=null, isDeleted=false)