Hello,
I have many SQL script files to update schema, delete data, unit test ....etc. I want to run all the files in one transaction using shell script to ease the installation procedure. I can do that from the psql client by using the \i option BEGIN; \i / .../ module1.sql \i / .../ module2.sql \i / .../ module_etc.sql COMMIT; Is there a way to do that using psql command shell script. I.E. I want to run the following in one transaction, psql -f module1.sql psql -f module2.sql psql -f module_etc.sql Thanks in advance
