获取以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");