How to import SQL dump into PostgreSQL

Make sure to have database first before dumping the data. If you don’t have database, create one inside psql with:

CREATE DATABASE database_name;

To import sql dump into PostgreSQL:

psql -h hostname -d databasename -U username -f file.sql

Reference

PostgreSQL Tutorial on create database
Stack Overflow on SQL dump into PostgreSQL