2.3k questions

2.3k answers

91.1k users

5 Online Users
1 Member 4 Guest
Online Members
Today Visits : 523
Yesterday Visits : 1995
Total Visits : 2215767

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