pgsql 查询所有表的主键和备注

最新推荐文章于 2024-06-15 15:36:27 发布

TaLinBoy

最新推荐文章于 2024-06-15 15:36:27 发布

阅读量1.1k

点赞数

文章标签：数据库 postgresql

本文链接：https://blog.csdn.net/TaLinBoy/article/details/129811345

版权

SELECT
   pg_constraint.conname AS pk_name,
   pg_attribute.attname AS colname,
   pg_type.typname AS typename,
   pg_stat_all_tables.schemaname as "schemaname",
   pg_stat_all_tables.relname as "table",
   cast(obj_description(relfilenode,'pg_class') as varchar) as comment
FROM
   pg_constraint
   INNER JOIN pg_class ON pg_constraint.conrelid = pg_class.OID
   INNER JOIN pg_attribute ON pg_attribute.attrelid = pg_class.OID AND pg_attribute.attnum = pg_constraint.conkey [ 1 ]
   INNER JOIN pg_type ON pg_type.OID = pg_attribute.atttypid
   INNER JOIN pg_stat_all_tables ON pg_stat_all_tables.relid = pg_class.OID
WHERE
   pg_stat_all_tables.schemaname = 'public'
   AND pg_constraint.contype = 'p';