Re: Exclude all child tables during while taking dump

From: Shrikant Bhende <shrikantpostgresql(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: Exclude all child tables during while taking dump
Date: 2020-03-16 10:49:29
Message-ID: CAMTQpJC2exa0yKY9wV-6e74ooNk2u89to_-0a9ugoe=FFOcPSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2020-03-16 16:26:04 Explain plan on a Select query
Previous Message Shrikant Bhende 2020-03-16 10:45:16 Exclude all child tables during while taking dump