many sql file and one transaction

From: salah jubeh <s_jubeh(at)yahoo(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: many sql file and one transaction
Date: 2011-10-18 12:11:22
Message-ID: 1318939882.80562.YahooMailNeo@web161516.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2011-10-18 12:21:45 Re: many sql file and one transaction
Previous Message leddy 2011-10-18 10:32:36 PostgreSQL - bindings were not allocated properly