title: How to execute multiple sql files in postgreSQL linux?
body: <p>I have many .sql files in a folder (/home/myHSH/scripts) in linux debian. I want to know the command to execute or run all sql files inside the folder into postgreSQL v9.1 database.</p>
  
  <p>PostgreSQL informations:</p>
  
  <pre><code>Database name=coolDB
  User name=coolUser
  </code></pre>
  
  <p>Nice to have: if you know how to execute multiple sql files through GUI tools too like pgAdmin3.</p>