0

I have 100 script files which has insert scripts for the table. How can I execute these?

Scrip1.sql , script2.sql, script3.sql .... script100.sql

To execute single file, I am using the below command. But how can I execute all files?

psql -d DBName -p 5444 -U schemaname -f P_Scrip1.sql  2> err.log
2

If you don't need to provide a password, it's easy:

for FILE in `ls -1 *.sql`
do
  psql -d DBName -p 5444 -U schemaname -f $FILE  2>$FILE.err.log
done

If you need to provide a password, concatenate all of the files together, then run psql:

for FILE in `ls -1 *.sql`
do
  cat $FILE >> /tmp/allfiles.sql
done

psql -d DBName -p 5444 -U schemaname -f /tmp/allfiles.sql 2>allfiles.err.log

rm /tmp/allfiles.sql 
| improve this answer | |
0

if you are using Linux you can use the following script

for ((i=1;i<101;i++)); do psql -d DBName -p 5444 -U schemaname -f P_Scrip${i}.sql 2> err.log & done
| improve this answer | |
  • file name is not unique . it is aa.sql , bb.sql ma.sql like that – asalthangam Oct 17 '16 at 12:47
  • I wrote the script based on the information on the question, based on your comment, my solution will not work. Phil answer will do the trick. – Ahmad Abuhasna Oct 17 '16 at 12:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.