在PostgreSQL数据库中如何判断一张表是否有主键,可以执行如下命令进行查询。
select
pg_constraint.conname as pk_name
from
pg_constraint
inner join pg_class on
pg_constraint.conrelid = pg_class.oid
where
pg_class.relname = 'test_table'
and pg_constraint.contype = 'p';
需要替换SQL语句中的表名。