How do I run an SQL file in PostgreSQL using a Linux terminal?

Question

I am working as a software tester. I want to to test my project locally. So I want to insert the database using the psql command. I tried so many times. I couldn't get to access the login page.

This is what I did:

postgres@naveen-Inspiron-3542:/home/naveen$ psql -U admin docmgr

Password for user admin:  psql (9.5.4) Type "help" for help.

docmgr=> psql docmgr -f /var/www/html/docmgr/application/assets/dd/structs/docmgr_21Oct2016.sql -U admin
docmgr-> \dt No relations found.

docmgr-> \dt No relations found.

docmgr-> select * from admin_users;

ERROR:  syntax error at or
 near "psql" LINE 1: psql docmgr -f
 /var/www/html/docmgr/application/assets/dd/st...
         ^

contents: sql create table queries. Does not get any error. It shows nothing. When I select a list of table "\dt " . It shows no relation found. I think the command is not working.. — Antony Naveen
– Antony Naveen, Commented Oct 24, 2016 at 9:17
The title says "How to dump the sql files in postgres ...", although in your question, you seem to ask "How to dump the sql files into postgres ...". So, what is it? Get data out of Postgres, or get data into Postgres? — Olaf Dietsche
– Olaf Dietsche, Commented Oct 24, 2016 at 9:22
My hypothesis: the file contains the text -- These are not the dumps you are looking for. Not very likely, but it fits with the information we've been given. — IMSoP
– IMSoP, Commented Oct 24, 2016 at 9:30

user330315user330315 · Accepted Answer · 2016-10-24 09:56:22Z

4

This is wrong:

docmgr=> psql docmgr -f /var/www/html/docmgr/application/assets/dd/structs/docmgr_21Oct2016.sql

You are running psql from within psql but "psql" is not a SQL statement.

You either need to run directly from the command prompt:

postgres@naveen-Inspiron-3542:/home/naveen$ psql -U admin -d docmgr -f /var/www/html/docmgr/application/assets/dd/structs/docmgr_21Oct2016.sql

Or from within psql you need to use the \i command to run a SQL script:

postgres@naveen-Inspiron-3542:/home/naveen$ psql -U admin docmgr

Password for user admin:  psql (9.5.4) Type "help" for help.

docmgr=> \i /var/www/html/docmgr/application/assets/dd/structs/docmgr_21Oct2016.sql

answered Oct 24, 2016 at 9:56

user330315

Sign up to request clarification or add additional context in comments.

2 Comments

Antony Naveen Over a year ago

postgres@naveen-Inspiron-3542:/home/naveen$ psql -U admin -d docmgr -f /var/www/html/docmgr/application/assets/dd/structs/docmgr_21Oct2016.sql Password for user admin: /var/www/html/docmgr/application/assets/dd/structs/docmgr_21Oct2016.sql: No such file or directory postgres@naveen-Inspiron-3542:/home/naveen$ psql -U admin docmgr Password for user admin: psql (9.5.4) Type "help" for help. docmgr=> \i /var/www/html/docmgr/application/assets/dd/structs/docmgr_21Oct2016.sql /var/www/html/docmgr/application/assets/dd/structs/docmgr_21Oct2016.sql: No such file or directory docmgr=>

Antony Naveen Over a year ago

Hai.. there is a one more issue. It is insert but when I put username and password. It could not access why?

Collectives™ on Stack Overflow

How do I run an SQL file in PostgreSQL using a Linux terminal?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related