Exclude all child tables during while taking dump

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Exclude all child tables during while taking dump

Shrikant Bhende-2
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
Reply | Threaded
Open this post in threaded view
|

Re: Exclude all child tables during while taking dump

Shrikant Bhende-2
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 <[hidden email]> 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