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