CODEWITHSUNDEEP
sqlwindowspostgresqlimport
David
David

Reputation: 16746

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.

Upvotes: 34

Views: 74428

Answers (7)

Jeremy Thompson
Jeremy Thompson

Reputation: 65702

If you're doing it with a URI connection string make sure the arguments are before the URI, Powershell examples:

Works on windows:

.\psql -f TestFile.sql $connString

.\psql -c 'SELECT Version();' $connString

Won't work on windows (URI connection before arguments):

.\psql $connString -c 'SELECT Version();'

Upvotes: 0

Soner from The Ottoman Empire
Soner from The Ottoman Empire

Reputation: 20921

psql -U <dbusername>
if the prompt makes you enter password, do that.
\c <yourdatabasename>
\i 'thepathusing/delimiter.sql'

Two points you need to watch out that

  • Use / as writing path of the file instead of \.
  • Use single quote symbol ' instead of ".

Upvotes: 2

Lucas Gervas
Lucas Gervas

Reputation: 379

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 & no spaces in file path

Upvotes: 21

Ipsita Upadhyay
Ipsita Upadhyay

Reputation: 131

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

Upvotes: 3

pcent
pcent

Reputation: 2049

You should use psql command line tool:

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

Upvotes: 56

AmaChefe
AmaChefe

Reputation: 405

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

Upvotes: 26

Tom
Tom

Reputation: 22841

This also works for me:

psql dbname username < file.sql

Upvotes: 13

Related Questions