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

On Thu, Jan 24, 2019 at 11:01 AM Ron wrote: > 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. That would be hard. There is an option to make psql show the queries it uses to i

Re: Need a command to take the backup of the child tables along with its 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

Need a command to take the backup of the child tables along with its master table.

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