Re: Exclude all child tables during while taking dump

Поиск
Список
Период
Сортировка
От Shrikant Bhende
Тема Re: Exclude all child tables during while taking dump
Дата
Msg-id CAMTQpJC2exa0yKY9wV-6e74ooNk2u89to_-0a9ugoe=FFOcPSQ@mail.gmail.com
обсуждение исходный текст
Ответ на Exclude all child tables during while taking dump  (Shrikant Bhende <shrikantpostgresql@gmail.com>)
Список 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@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 по дате отправления:

Предыдущее
От: Shrikant Bhende
Дата:
Сообщение: Exclude all child tables during while taking dump
Следующее
От: John Scalia
Дата:
Сообщение: Explain plan on a Select query