Postgres 数据字典-主键

获取以d_开头的表的主键：

SELECT
	cl.relname AS tbl_name,
	co.conname AS pk_name
FROM
	pg_constraint co,
	pg_class cl
WHERE
	co.conrelid = cl.oid
AND co.contype = 'p'
AND cl.relname LIKE 'd_%'

对主键的增删改：

#增加：
ALTER TABLE "mo"."mo_user"
ADD CONSTRAINT "pk_mo_user" PRIMARY KEY ("recmo_id");


#删除
ALTER TABLE "mo"."mo_user"
DROP CONSTRAINT "mo_user_pkey";


#修改
ALTER TABLE "mo"."mo_user"
DROP CONSTRAINT "mo_user_pkey" ,
ADD CONSTRAINT "pk_mo_user" PRIMARY KEY ("recmo_id");