0 votes
How do you copy data from a prod database to a dev database for some tables only in PostgreSQL (postgresql, PG dump, dbeaver, development)?
in General by (73.3k points) | 40 views

1 Answer

0 votes

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.

by (73.3k points)

1.8k questions

1.8k answers

85.0k users

14 Online Users
0 Member 14 Guest
Today Visits : 718
Yesterday Visits : 3892
Total Visits : 2009133
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.
1,829 questions
1,840 answers
85,033 users
@ 2022 V Katsanioti ,All rights reserved