分类：表名

2021
01-08

postgresql 实现获取所有表名,字段名,字段类型,注释

获取表名及注释：selectrelnameastabname,cast(obj_description(relfilenode,'pg_class')asvarchar)ascommentfrompg_classcwhererelkind='r'andrelnamenotlike'pg_%'andrelnamenotlike'sql_%'orderbyrelname过滤掉分表：加条件andrelchecks=0即可获取字段名、类型、注释、是否为空：SELECTcol_description(a.attrelid,a.attnum)ascomment,format_type(a.atttypid,a.atttypmod)astype,a.attname... 继续阅读 >

2020
10-10

mybatis-plus 表名添加前缀的实现方法

1、使用mybatis-plus自身的查询构造去，只需要在全局配置中添加如下配置mybatis-plus:mapper-locations:classpath:mappers/*Mapper.xml#mapper映射文件global-config:db-config:table-prefix:tr_2、自定义sql语句中添加表名前缀在yml文件中添加如下配置mybatis-plus:mapper-locations:classpath:mappers/*Mapper.xml#mapper映射文件global-config:db-config:table-prefix:tr_configuration-properties:... 继续阅读 >