Transfer data from one database to another (Postgres)

Question

I have two identical databases on two different machines (with different data), and I want to transfer the contents of one table to a table from another database, how to do it from PgAdmin? I am new to PostgreSQL Database, I would do it easily with mysql phpmyadmin, just export sql and I would get a text file with a bunch of insertion into statements, is there an equivalent to PgAdmin?

Answer 1

Yes, backup using the "PLAIN" format (SQL statements), and then (when connecting to another database) open the file and run it.

"COMPRESS" "backup", restore.

phpMyAdmin Postgres, "phppgadmin" . "".

Answer 2

pg_dump