postgis获取主键字段名和主键约束名称并去掉主键

-- 获取主键字段名和主键约束名称
SELECT
    a.attname AS column_name,
    conname AS constraint_name
FROM
    pg_index i
JOIN
    pg_attribute a ON a.attrelid = i.indrelid  AND a.attnum = ANY(i.indkey) 
JOIN
    pg_constraint c ON c.conindid = i.indexrelid
WHERE
    i.indisprimary AND i.indrelid = 'smsqfwxx_match'::regclass AND i.indisprimary;

上面获取主键约束名称是 smsqfwxx_match_pkey

-- 取消主键
ALTER TABLE smsqfwxx_match DROP CONSTRAINT smsqfwxx_match_pkey;