This is actually an interesting question. I don't understand which approach to use. I am using pd_dump and pg_restore of the receiving server. It might make sense to use pg_dump source, pg_restore sink
Adrian Klaver <adrian.klaver@aklaver.com> writes: > On 11/20/21 04:27, Дмитрий Иванов wrote: >> Why does pg_dump generate an insertion script in the generated columns?
> Actually I think it should be DEFAULT.
It should be, and it is when I try this example. I get output like
-- -- Data for Name: object; Type: TABLE DATA; Schema: bpd; Owner: postgres --