Assume you want to clone all data of table Abc into a database in a different machine.
- At src machine:
PGPASSWORD=password sudo pg_dump --host localhost --port 5432 --username username --format plain --verbose --file '/tmp/Abc.bak' --table Abc databasename
-
Copy file to dst machine.
-
At dst machine: