title: How to execute *.sql file using psql
body: <p>I have created an <code>index.sql</code> file which contains  index creating script for <code>95 table</code></p>
  
  <p>for example</p>
  
  <pre><code>DROP INDEX IF EXISTS gtab03_vrctrlid_idx cascade;
  CREATE UNIQUE INDEX gtab03_vrctrlid_idx ON gtab03 USING btree (vrctrlid);
  </code></pre>
  
  <p>I have consolidated all table's <code>index creating script</code> to a file called <code>index.sql</code>
  I need to run the entire script at a time, is it possible to execute the <code>index.sql</code> file using <code>psql</code></p>