I would like to know how to execute a .sql file in PostgreSQL. I'm using CentOs 6.4.
I have created a database and just need to run a script given to me to create tables.
Thanking you in advance.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
If you already logged in to database then you can use meta commands like
db=# \i or \include filename
For more info see doc
I am adding this it might be useful who try to execute *.sql place where PostgreSQL server located in a difference place.
psql -h localhost -d userstoreis -U admin -p 5432 -a -q -f /home/jobs/Desktop/resources/postgresql.sql
These are the usage of each parameter
-h PostgreSQL server IP address -d database name -U user name -p port which PostgreSQL server is listening on -f path to SQL script
then you are prompted to enter the password of the user.