Postgres Pro
Downloads
Home   >   mailing lists

Re: Exclude all child tables during while taking dump - Mailing list pgsql-admin

From Shrikant Bhende
Subject Re: Exclude all child tables during while taking dump
Date
Msg-id CAMTQpJC2exa0yKY9wV-6e74ooNk2u89to_-0a9ugoe=FFOcPSQ@mail.gmail.com
Whole thread Raw
In response to Exclude all child tables during while taking dump  (Shrikant Bhende <shrikantpostgresql@gmail.com>)
List pgsql-admin
Tree view
Hello, 

Added info : 

All the partitions are created using INHERITS, using customer_id as partition key. 

On Mon, Mar 16, 2020 at 4:15 PM Shrikant Bhende <shrikantpostgresql@gmail.com> wrote:
Hello,
I am trying to take  schema only dump of a database using pg_dump, but seems like there's no option to exclude child tables. I need to take dump of schema of parent tables not the child tables, is there any way to exclude all the child tables for all the tables? 
PostgreSQL version 12.


Thanks and regards

pgsql-admin by date:

Previous
From: Shrikant Bhende
Date:
Subject: Exclude all child tables during while taking dump
Next
From: John Scalia
Date:
Subject: Explain plan on a Select query