PG数据库结构备份还原时不会包含序列号的值,通过以下SQL导出同步语句
select format($$
select setval(‘%s.%s’::regclass, %s);$$,
relnamespace::regnamespace::text,
oid::regclass::text,
coalesce(pg_sequence_last_value(oid),
(pg_sequence_parameters(oid)).start_value) + 1)
from pg_class where relkind=‘S’;