Importing back a database dump from PosgreSQL is quite easy and with most import scripts it only takes one line.

psql -d database_name -U username -f database.dump
  • database_name — Your Database name to import the dump to
  • username — Your username that connects to the database
  • database.dump — Your database dump

Your database might ask additional information like your user’s password:

Password for user postgres: 

Type in your password and voila! Your database will be imported.