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.

Importing data

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

You may also like...