On 1/24/19 3:40 AM, Raghavendra Rao J S V wrote:
> Hi All,
>
> We have one master table and multiple child tables (dependent tables)
> associated with it.
>
> While taking the backup of the master table , I would like to take the
> backup of all its child (dependent) tables backup also.
>
> Please guide me how to take the backup of the master table and its
> dependent tables using *pg_dump *command.
>
Do you know the list of dependent tables? If so, you can list them in the
"pg_dump --table=" clause.
If not, you'll have to do some bash magic in parsing the "Foreign-key
constraints:" clause of "\d your_table_name" and stuff them in the "pg_dump
--table=" clause.
--
Angular momentum makes the world go 'round.