Re: Need a command to take the backup of the child tables along withits master table.

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.