쉘스크립트로 sql파일들 여러개 실행하기

 

#!/bin/bash
for f in *.sql;
do
        psql -U postgres -d postgres -f "$f"
done

echo "sql runner complete";

 

https://stackoverflow.com/questions/13062168/how-to-execute-multiple-sql-files-in-postgresql-linux

How to execute multiple sql files in postgreSQL linux?