I need to make a dump main table with tables-partitions in one file. Is it possible to do this with some commands in postgresql console or with pg_dump?
Thanks.
I need to make a dump main table with tables-partitions in one file. Is it possible to do this with some commands in postgresql console or with pg_dump?
Thanks.
Copyright © 2021 Jogjafile Inc.
Something like this should work. It will recreate the table AND partitions :