Importing data of postgresql database with psql
psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results. Alternatively, input can be from a file. In addition, it provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks.
E:\postgre\bin>psql -U <user name> -d <database name> -f <import file name.sql>
E:\postgre\bin>psql -U postgres -d databaseName -f importFile.sql