On 12/2/20 5:49 PM, David G. Johnston wrote:
On Wednesday, December 2, 2020, Tom Lane <tgl@sss.pgh.pa.us> wrote:
What you need here is something like "pg_dump -t measurement*"
to indicate that you want measurement's child tables too, but
AFAIR pg_dump has no such feature.
-t accepts a pattern in pg_dump. But that requires the user to adhere to a naming scheme.
Not only adhering to a naming scheme, but ensuring that there aren't any other tables which match "measurement*".
--
Angular momentum makes the world go 'round.