- Elias
Topic Author- Offline
- Administrator

Less More- Posts: 4306
- Thank you received: 0
6 months 6 days ago#3330by Elias How do you copy data from a prod database to a dev database for some tables only in PostgreSQL (postgresql, PG dump, dbeaver, development)?
- Elias
Topic Author- Offline
- Administrator

Less More- Posts: 4306
- Thank you received: 0
6 months 6 days ago#3331by Elias 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.
- Q&A
- Index
- Database
- data from prod to dev
Time to create page: 0.129 seconds