October 18, 2011 3:23 PM
Subject: Re: [GENERAL] many sql file and one transaction
On Tue, Oct 18, 2011 at 7:57 AM, Cédric Villemain
wrote:
> 2011/10/18 salah jubeh :
>> Hello,
>> Thanks for the reply.
>> I considered cat as an option but I did not go for it, because of the
&
; Regards
>>
>>
>>
>>
>>
>>
>> From: "andr...@a-kretschmer.de"
>> To: salah jubeh
>> Sent: Tuesday, October 18, 2011 2:23 PM
>> Subject: Re: [GENERAL] many sql file and one transaction
>>
&g
salah jubeh
> Sent: Tuesday, October 18, 2011 2:23 PM
> Subject: Re: [GENERAL] many sql file and one transaction
>
>
> Zitat von salah jubeh :
>
>> Hello,
>>
>>
>> I have many SQL script files to update schema, delete data, unit
>> test etc. I want to
causing the error.
Regards
From: "andr...@a-kretschmer.de"
To: salah jubeh
Sent: Tuesday, October 18, 2011 2:23 PM
Subject: Re: [GENERAL] many sql file and one transaction
Zitat von salah jubeh :
> Hello,
>
>
> I have ma
On 18 October 2011 14:11, salah jubeh wrote:
> 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 o
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 / .../