dropdb --if-exists stats_src
createdb stats_src

psql -X -v ON_ERROR_STOP=1 stats_src <<'SQL'
CREATE SCHEMA s1;
CREATE SCHEMA s2;

CREATE TABLE s1.t AS
  SELECT g AS a, g % 10 AS b
  FROM generate_series(1, 1000) AS g;

CREATE TABLE s2.t AS
  SELECT g AS a, g % 10 AS b
  FROM generate_series(1, 1000) AS g;

CREATE STATISTICS s1.st ON a, b FROM s1.t;
CREATE STATISTICS s2.st ON a, b FROM s2.t;

ANALYZE s1.t;
ANALYZE s2.t;
SQL

pg_dump --statistics-only -n s1 -f /tmp/plain-s1-stats.sql stats_src

pg_dump --statistics -Fc -f /tmp/stats.dump stats_src
pg_restore --statistics-only -n s1 -f /tmp/archive-s1-stats.sql /tmp/stats.dump

echo 'plain pg_dump:'
grep -E 'pg_restore_(relation|attribute|extended)_stats' /tmp/plain-s1-stats.sql

echo 'archive pg_restore:'
grep -E 'pg_restore_(relation|attribute|extended)_stats' /tmp/archive-s1-stats.sql

