How to execute SQL commands from a file in postgresql?

Question: How to execute SQL commands from a file in postgresql?

In my case I had a .sql file with hundreds of insert statements and I wanted to run all of them, I was left with two options namely manually entering every command via copy and paste or executing the file. I went for the second option and it worked. I used Postgres 8.4 on the command line on a Ubuntu machine.

Answer:

Please follow the following steps

• Connect to the relevant database eg.

  sudo -u postgres psql MYDB

• Then run

  \i MYFILEWITHCOMMANDS.SQL

  \i means execute commands from file
• All commands will be executed.  

• Add New Search
• Comments

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.