Re: pg_dump of partitioned table not working.

Ron <ronljohnsonjr@xxxxxxxxx> · Wed, 2 Dec 2020 18:09:23 -0600



    On 12/2/20 5:49 PM, David G. Johnston wrote:

    
      On Wednesday, December 2, 2020, Tom Lane <tgl@xxxxxxxxxxxxx>
      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.