How to transfer data from one table in one database to another table in another database?

Y

yellow_pus2022-01-30 12:40:39

PostgreSQL

yellow_pus, 2022-01-30 12:40:39

I have two different databases but with one identical table. Is it possible to somehow transfer all the data from one table in one database to another table in another database?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

S

Sergey Gornostaev, 2022-01-30
@yellow_pus

https://postgrespro.ru/docs/postgrespro/10/contrib...

D

Dimonchik, 2022-01-30
@dimonchik2013

beautiful request will not work, but export import - yes
or so
https://stackoverflow.com/questions/3049864/transf...
or through a client (datagrip etc)