This assumes you have already Backed a Postgres database using the pg_dump command.

Let's say you have created a file named foo.backup that contains a backup of the foo database.

pg_dump foo > /path/to/foo.backup

Here is how you can import (restore) the foo database using the psql command.

psql --username john.doe --dbname foo < /path/to/foo.backup