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

Question

How do you copy data from a prod database to a dev database for some tables only in PostgreSQL (postgresql, PG dump, dbeaver, development)?

Answer 1

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.