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
1
  • Create one file that calls all the others.
    – user1822
    Oct 17, 2016 at 12:38

2 Answers 2

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 
2
  • i need to provide password ... Oct 17, 2016 at 12:46
  • @asalthangam: providing a password for that is a different question then "how do I run 100 SQL scripts" - see here for an answer to that: dba.stackexchange.com/questions/14740/…
    – user1822
    Oct 17, 2016 at 12:50
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
2
  • file name is not unique . it is aa.sql , bb.sql ma.sql like that Oct 17, 2016 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. Oct 17, 2016 at 12:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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