2.4k questions

2.4k answers

96.4k users

5 Online Users
0 Member 5 Guest
Today Visits : 1346
Yesterday Visits : 2014
Total Visits : 2371803

Categories

Notice

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

Information

Viktoria Katsanioti,

Kaliningrad,

Russia,

matizegr@yahoo.com

0 votes
85 views
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 (95.8k points)

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 (95.8k points)
...