Transfer postgres database table from one server to another?

Question

The pgAdmin gui will not work for the destination database because it is on a vagrant server which is not supported by pgAdmin3.

I would like to copy a database table from one server to another. What is the easiest way to do this?

Answer 1

As everyone has said in the comment. The canonical and supported way to do this is with pg_dump or pg_dumpall. Look at the respective man pages. Both are very simple to use.