On 12/2/20 5:42 PM, David G. Johnston wrote:
On Wednesday, December 2, 2020, Ron <ronljohnso...@gmail.com
<mailto:ronljohnso...@gmail.com>> wrote:
What am I missing?
postgres=# \d+ measurement
Partitioned table "public.measurement"
$ /usr/lib/postgresql/12/bin/pg_dump -p5433 -d postgres -t measurement
--data-only
I’m unsure whether to expect a dump of only the partitioned table’s data
to be empty or include everything. I suspect “empty” is the correct
answer. If you dump everything the individual tables would be dumped, and
not all partition should be dumped.
The individual partition tables regularly (for some site-specific definition
of "regularly") change, as new partitions are added and old partitions are
dropped. Or the DBA decides to change the partition scheme.
Needing to remember all the partition names is absurd, especially when there
might be dozens of them
--
Angular momentum makes the world go 'round.
