可以试试checksum的函数
创建语句
create function checksum_row(bigint, text) returns bigint
as 'select int8pl($1, hashtext($2))' language sql;
create aggregate checksum(text)
(
sfunc = checksum_row,
stype = bigint,
initcond = 0,
combinefunc = int8pl
);
使用方式
select checksum(a::text) from 表名 a;
select checksum(列名::text) from 表名;
这可以就可以方便的进行全量,增量的数据比对了