SELECT
t4.tablename AS tableName,
string_agg(DISTINCT t3.attname,',') AS primaryKeyColumn
FROM
pg_constraint t1
INNER JOIN pg_class t2 ON t1.conrelid = t2.oid
INNER JOIN pg_attribute t3
pg数据库获取库下所有表的主键信息的sql
最新推荐文章于 2023-12-18 17:06:41 发布