Postgresql

Restore Database dump file For Postgresql using Terminal(Command line) :

     - Open Terminal and go to folder(path) where your .sql file is exist and than type following command and hit enter
                         - psql -U {user-name} -d {desintation_db} -f {dumpfilename.sql}

                          where,
                                       user-name is your database username
                                       destination_db is your database in which you will store your dump
                                       dumpfilename.sql is your file dump file for restore

                         example :  psql -U tarachand -d student -f myfile.sql