Skip to main content
Database Administrators

Return to Question

edited tags
Link
user1822
user1822
deleted 41 characters in body
Source Link
user1822
user1822

I have 100 script files which has insert scripts for the table. How can iI execute these. what is the script i can use it.?

Scrip1.sql , script2.sql, script3.sql .... script100.sql
 
to execute single file , i am using the below command. but to execute all the files how can i?

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

I have 100 script files which has insert scripts for the table. How can i execute these. what is the script i can use it.

Scrip1.sql , script2.sql, script3.sql .... script100.sql
 
to execute single file , i am using the below command. but to execute all the files how can i?

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

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
Source Link
asalthangam
asalthangam
  • 303
  • 1
  • 5
  • 8

How to execute multiple postgres script from command prompt

I have 100 script files which has insert scripts for the table. How can i execute these. what is the script i can use it.

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

to execute single file , i am using the below command. but to execute all the files how can i?

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