execute sql files from a folder in postgres

Question

I have a set of sql files placed in a folder in postgres docker image. Whenever a new account is created, I want a new database to be created and all these scripts should get executed on that new created database.

New database will be created manually. I need to create sh file to ask for db name, host, port, password etc and then execute all sql files on new created database.

I tried and I can execute one single file

psql -h localhost -d sampledb -U superuser -f sample.sql

I need to execute all files in the folder. How I can achieve this.

Mad Wombat · Accepted Answer · 2019-10-21 15:34:35Z

2

Here, you can make use of small bash script. Copy all your sql files to a folder, for example test. Then execute the below line of script.

for i in $(ls -l test/*.sql |awk '{print $NF}'); do 
    psql -h localhost -d sampledb -U superuser -f $i; 
done

edited Oct 21, 2019 at 15:34

Mad Wombat

15.3k15 gold badges78 silver badges114 bronze badges

answered Oct 21, 2019 at 15:32

Sreejith

4645 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

execute sql files from a folder in postgres

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related