PostgreSql
Zhangmaoyang
这个作者很懒,什么都没留下…
展开
-
PostgreSQL导出待注释的的表结构为Excel
select a.attnum AS "序号",c.relname AS "表名",cast(obj_description(relfilenode,'pg_class') as varchar) AS "表名描述",a.attname AS "列名",concat_ws('',t.typname,SUBSTRING(format_type(a.atttypid,a.atttypmod) from '\(.*\)')) as "字段类型",d.description AS "备注"from pg原创 2020-07-09 10:03:28 · 1145 阅读 · 0 评论 -
PostgreSql&Mysql使用TkMybatis的insert或者insertSelective返回主键
MySQL: 在实体类主键字段上使用: @Id@GeneratedValue(strategy = GenerationType.IDENTITY,generator = "JDBC")PostgreSQL: 在实体类主键字段上使用:@Id@KeySql(useGeneratedKeys = true)@Column(name = "id",insertable = false)稍微有点区别,记录一下,另外 PostgreSQL使用Myb...原创 2020-05-24 18:02:24 · 2372 阅读 · 1 评论