Importing .sql file on windows to postgresql

Question

I have a .sql file that was created by postgresql a while back. I now want to import this file onto a windows machine running postgresql.

How do I do this. The file is about 1.5gb.

Answer 1

You should use psql command line tool:

psql -h hostname -p port_number -U username databasename -f your_file.sql