Importing .sql file on windows to postgresql

问题:

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.

回答1:

You should use psql command line tool:

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

回答2:

click on the SQL Shell and log into the database and use import

Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
Password for user postgres:
psql (9.2.4)
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
Type "help" for help.

postgres=# \i c:/data/data01.sql

回答3:

This also works for me:

psql dbname username < file.sql

回答4:

start you psql command tool, it will give you dialog like the following

Server [localhost]:
Database [postgres]:
Port [5432]:yourport
Username [postgres]:
Password for user postgres:**********

then connect to your database

postgres=# \c yourdatabase;

then import the file

yourdatabase=# \i c:/path/path/data/data01.sql

note the / for directory separator

回答5:

command prompt

open your cmd window and type the following (make sure the path of postgres is correct)

."C:\Program Files\PostgreSQL\9.4\bin\psql.exe" -h 127.0.0.1 -p 5432 -U postgres -d dbname <./query.sql