Script creating multiple indexes

Question

How can i create a Postgresql script to create multiple indexes?

I've a list of 'CREATE INDEX' statements and don't want to execute the one by one. So it would be nice to have a script for this job.

Postgresql 9.1

Can you explain me how. How to seperate the commands ? Is it possible to add them in a file (one command per line) and use psql -f <filename> ? — John Doe
– John Doe, Commented Aug 25, 2014 at 11:27
Already tried to seperate them bij ';' but that doesn't work. Only the first one executes. — John Doe
– John Doe, Commented Aug 25, 2014 at 11:29
For others who also struggle with this. After some trail and error, this works for me: psql -d <db_name> -f <file_name> One command per line in file. — John Doe
– John Doe, Commented Aug 25, 2014 at 11:50

Andrzej Reduta · Accepted Answer · 2014-08-25 11:55:51Z

1

Try this command

  psql -f file_path db_name

answered Aug 25, 2014 at 11:55

Andrzej Reduta

7771 gold badge7 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1