Forum

data from prod to d...
 
Notifications
Clear all

data from prod to dev


(@elias)
Illustrious Member
Joined: 5 months ago
Posts: 4277
Topic starter  

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


   
Quote
(@elias)
Illustrious Member
Joined: 5 months ago
Posts: 4277
Topic starter  

you must disable constrainsexport the data of all relative tables in INSERT statements from source or all the tables with drop option and create optiongo to the destination databaserun the script thatDrop the relative tablesCreate and populate themenable constraints.


   
ReplyQuote
Share: