- 博客(3)
- 收藏
- 关注
原创 pgsql(postgresql) 获取用户数据表,显示主键,说明,索引大小,表大小
SELECT tb.relname AS "name", pg_size_pretty(pg_total_relation_size('"' || schemaname || '"."' || tb.relname || '"')) AS "reserved", pg_size_pretty(pg_table_size('"' || schemaname || '"."' || tb.relname || '"')) AS "data", pg_size_pretty(pg_inde
2021-08-31 15:29:36 701
原创 pgsql(postgresql) 查询获取字段名,字段类型,长度,主键,非空,自增,默认值,描述
postgresql 获取字段名,字段类型,长度,主键,非空,默认值代码效果代码select c.relname as 表名, a.attname as 列名, (case when a.attnotnull = true then true else false end) as 非空, (case when ( select count(pg_constraint.*) from pg_constraint inner join pg_class on
2021-08-13 16:47:00 8957 4
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人