×

Notice

The forum is in read only mode.

data from prod to dev

  • Elias
  • Elias's AvatarTopic Author
  • Offline
  • Administrator
  • Administrator
More
5 months 2 weeks 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
  • Elias's AvatarTopic Author
  • Offline
  • Administrator
  • Administrator
More
5 months 2 weeks 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.
Time to create page: 0.165 seconds

Contact

Site Info

V. Katsanioti,

Russia,

Kaliningrad Oblast.

matizegr@yahoo.com

Visit counter

United States of America (the)70.0%United States of America (the)
Russian Federation (the)14.6%Russian Federation (the)
China10.2%China

Total:

44

Countries
00004710
Today:41
Yesterday:61

Who's Online

We have 100 guests and no members online