Search Postgresql Archives

many sql file and one transaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux