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.
