Knowledge Base

How to copy a table from DB to DB on PostgreSQL

To move a table from a database in PostgreSQL to a newly established or existing database, you can use the code below and move the table in a single line.


The table should not be created on the new server (172.2.3.5). 


Command: PGPASSWORD="PASSWORD" pg_dump -h 172.2.3.4 -U postgres -t table_name db_name | PGPASSWORD="PASSWORD2" psql -h 172.2.3.5 -d new__db_name -U postgres


NOTE: Be careful not to forget to set the firewall rules between the servers.