Running multiple SQL files in a single transaction of PostgreSQL on Windows

Question

I am trying to run multiple SQL files in a single transaction of PostgreSQL. In Linux environments this can actually be achieved by using here-document as:

psql -U postgres -h localhost -d mydatabase << files
BEGIN;
\i file1.sql
\i file2.sql
commit;
files

But I am unable to achieve the same in Windows environment.

Put everything in a SQL script and then use psql .. -f commands.sql — user330315
– user330315, Commented Dec 16, 2017 at 8:50
If the here document you have shown works in Linux, the this will also work as a single file in Windows — user330315
– user330315, Commented Dec 16, 2017 at 9:55

user330315 · Accepted Answer · 2017-12-16 09:55:26Z

7

Put everything in a one file, e.g.

\i file1.sql
\i file2.sql

Then call psql with the -f parameter. To force a single transaction use --single-transaction

psql -U postgres -h localhost -d mydatabase --single-transaction -f the_script.sql

answered Dec 16, 2017 at 9:55

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Running multiple SQL files in a single transaction of PostgreSQL on Windows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related