select pg_attribute.attname as colname,pg_type.typname as typename 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 array_position(pg_constraint.conkey,pg_attribute.attnum) is not null
inner join pg_type on pg_type.oid = pg_attribute.atttypid
where pg_class.relname = 'table_name'
and pg_constraint.contype='p'
PgSQL查询一张表内的所有主键信息
最新推荐文章于 2023-12-18 17:06:41 发布