How do you copy data from a prod to a dev database for some tables only in PostgreSQL ?

Question

1 Answer

Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you, Elias Katsaniotis, MSc.

EKatsaniotis · Answer 1 · 2022-05-20T04:43:53+0000

you must disable constrains

export the data of all relative tables in INSERT statements from source or all the tables with drop option and create option

go to the destination database

run the script that

Drop the relative tables

Create and populate them

enable constraints.

How do you copy data from a prod to a dev database for some tables only in PostgreSQL ?

Your answer

1 Answer

Categories