Sample Header Ad - 728x90

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