How to batch up Postgres files

Question

I have a number of files which need to be run against a postgres database. They are stored as separate files for reasons of maintenance and configuration management. I am using this type of method to run them

acro =# \i ./psql.sql   
acro =# \i ./psql.function1.sql
acro =# \i ./psql.function2.sql
acro =# \i ./psql.function3.sql
acro =# \i ./psql.function4.sql

etc

Is there a way to batch these commands or these file names up, so that they can be run as a single interactive command ?

Thanks

cat psql.sql psql.function1.sql psql.function2.sql | psql

Abelisto
– Abelisto

2016-12-12 12:31:06 +00:00
Commented Dec 12, 2016 at 12:31 — Abelisto
– Abelisto, Commented Dec 12, 2016 at 12:31
Thanks for the suggestion.

MHugh
– MHugh

2016-12-12 13:58:12 +00:00
Commented Dec 12, 2016 at 13:58 — MHugh
– MHugh, Commented Dec 12, 2016 at 13:58

Laurenz Albe · Accepted Answer · 2016-12-12 12:14:35Z

1

You can simply create a file batch.sql that looks like this:

\i ./psql.sql   
\i ./psql.function1.sql
\i ./psql.function2.sql
\i ./psql.function3.sql
\i ./psql.function4.sql

and run it with psql -f batch.sql.

answered Dec 12, 2016 at 12:14

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

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

3 Comments

Gurmokh Over a year ago

this file would need to be edited everytime a new file is added or removed.

Gurmokh Over a year ago

Loop thorugh files in a directory. Something like : for f in *; do \i ./psql $f; done

MHugh Over a year ago

Thanks for the suggestion.

Collectives™ on Stack Overflow

How to batch up Postgres files

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related