Import table data using multiple sql file in psql
0
votes
0
answers
566
views
Local Machine(l1):
Windows 10
psql
Remote Machine(R1):
linux
EDB(postgres)
On my local I have 1000+ sql script containing insert statement . psql is also installed locally .
I need to run this sql script from my local command prompt using psql client .
I can connect to remote db as
psql -h hostnme -U username -p port DBName
. For single file i know that it can be run like \i f.sql
. I also tried combining all sql file in one file on windows using command copy /b *.sql new.sql
. But the new sql file size is 4 GB . Which is not easy to work with . Is there any way I can run those 1000+ sql script from psql without combining from command prompt ?
Asked by user236778
(35 rep)
Jul 6, 2020, 10:55 AM