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;
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