PostgreSQL pg 生成数据字典，查询表索引，主键

最新推荐文章于 2024-07-22 17:15:18 发布

ac.char

最新推荐文章于 2024-07-22 17:15:18 发布

阅读量1k

点赞数

分类专栏： PostgreSQL 文章标签： postgresql 数据库

本文链接：https://blog.csdn.net/sunny_day_day/article/details/121483606

版权

select
(select relname||'--'||(select description from pg_description where objoid=oid and objsubid=0) as comment from pg_class where oid=a.attrelid) as table_name,
a.attname as column_name,
format_type(a.atttypid,a.atttypmod) as data_type,
(case when atttypmod-4>0 then atttypmod-4 else 0 end)data_length,
(case when (select count(*) from pg_constraint where conrelid = a