On 12/2/20 5:49 PM, David G. Johnston wrote:
> On Wednesday, December 2, 2020, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
> <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)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.