迁移后验证数据正确性

Private preview

比较所有表的行数

迁移完成后，验证数据是否正确的一种简单方法是比较源数据库和目标数据库中所有表的行数。您可以在两个数据库中分别运行以下查询：

SELECT table_name, 
       (xpath('/row/cnt/text()', xml_count))[1]::text::bigint AS row_count
FROM (
  SELECT table_name, 
         query_to_xml('SELECT count(*) AS cnt FROM ' || quote_ident(table_name), false, true, '') AS xml_count
  FROM information_schema.tables
  WHERE table_schema = 'public'
) t
ORDER BY table_name;