数据库
南瓜微微
数据库,大数据开发,人工智能,深度学习,图像识别,视频检测,AGI,opencv,opencl,cuda,pytorch。
展开
-
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 · 694 阅读 · 0 评论 -
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 · 8815 阅读 · 4 评论