How to run a .sql file with phppgadmin or psql

Question

While importing .sql file in phppgadmin it produces an error

"Import error: Failed to automatically determine the file format".

How to import the file?

And in terminal it shows as

postgres-# \i Documents/sample.sql

Documents/sample.sql: No such file or directory

But the file exists in the particular location. How to import .sql file in Postgresql and in Phppgadmin

Your relative path probably doesn't work from the current directory. `\i` **does** work with SQL scripts. Try to supply the **full** path to the file. — , Oct 15 '16 at 08:04

score 0 · Accepted Answer · answered Oct 15 '16 at 05:00

0

You can do this by command line:

Get login with your psql through command line and
just run the following command in your terminal

psql 'databasename' < 'database_dump'

just replace 'databasename' with your database and 'database_dump' with the file you want to import.

answered Oct 15 '16 at 05:00

Amrinder Singh

will "psql 'databasename' < 'database_dump'" work importing a .sql file – Rajasree Oct 15 '16 at 05:40
By using this codepostgres-# psql postgres < ../Music/datahere.sql – Rajasree Oct 15 '16 at 05:48
it doesnot produce any error but do data is imported in phppgadmin – Rajasree Oct 15 '16 at 05:48
what's the name of your database? – Amrinder Singh Oct 15 '16 at 05:49
postgres is the name of the database – Rajasree Oct 15 '16 at 05:51
then check the path of your sql file, there must some issue – Amrinder Singh Oct 15 '16 at 05:54
You are welcome, you can also upvote the answer, that will be really helpful :) – Amrinder Singh Oct 15 '16 at 06:29

ItsYourWorld · Answer 2 · 2019-11-10T15:57:02.837

0

You can run a file using below command

psql -U postgres -d postgres -a -f ./test.sql

or if you have to pass a host

psql -h -p 5432 -U postgres -d -a -f ./test2.sql

edited Nov 10 '19 at 15:57

answered Nov 03 '19 at 06:34

ItsYourWorld

2 Answers2