Postgres Pro
Downloads
Home   >   mailing lists

Re: Concurrently run scipts - Mailing list pgsql-sql

From hector vass
Subject Re: Concurrently run scipts
Date
Msg-id CAJJx+iVhpkKtm=MGNOMSedEsOOHpqeZ+=Vvjj_5n5-sCdH5U6Q@mail.gmail.com
Whole thread Raw
In response to Re: Concurrently run scipts  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Concurrently run scipts  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view
Concurrently but independently 
psql -f script1 & psql -f script2 && fg
Similar in windows can be achieved using start iirc

On Wed, 25 Oct 2023, 21:15 Bruce Momjian, <bruce@momjian.us> wrote:
On Wed, Oct 25, 2023 at 08:57:03PM +0100, Shaozhong SHI wrote:
> In psql  we run scripts sequentially like the following:
>
> \ir script1
> \ir script2
>
>
> Is there something similar for concurrent running script?

Uh, yeah, see the use of \! and & starting on slide 59:

        https://momjian.us/main/writings/pgsql/locking.pdf

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Concurrently run scipts
Next
From: Shaozhong SHI
Date:
Subject: Re: Concurrently run scipts