How to execute *.sql file using psql

Question

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

Accepted Answer

Following script worked for me,

```
psql -U postgres -d mydb -a -f "D:\index.sql" -- Absolute path to .sql file
```

-U, -a, -f

How to execute *.sql file using psql

Solution

Problem