public inbox for pgsql-novice@postgresql.org  

help / color / mirror / Atom feed
From: Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
To: Laurenz Albe <laurenz.albe@cybertec.at>
To: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Subject: AW: Executing INSERTs from a file but with a wait delay.
Date: Tue, 14 Apr 2026 11:04:21 +0000
Message-ID: <42ef83b5fdad4d8787855260a39a232e@alte-leipziger.de> (raw)
In-Reply-To: <248dbae08b024e035a3ef1811d20f8defa8f232c.camel@cybertec.at>
References: <ebf0d5681be44a72807aca0ee6b0e1ea@alte-leipziger.de>
	<248dbae08b024e035a3ef1811d20f8defa8f232c.camel@cybertec.at>

Thank you so much.  馃槉











Freundliche Gr眉脽e

i. A. Ramachandran Subramanian
Zentralbereich Informationstechnologie

Alte Leipziger Lebensversicherung a.G.


Hallesche Krankenversicherung a.G.







Alte Leipziger Lebensversicherung a.G., Alte Leipziger-Platz 1, 61440 Oberursel
Vors. des Aufsichtsrats: Dr. Walter Botermann 路 Vorstand: Christoph Bohn (Vors.), Dr. J眉rgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek
Sitz Oberursel (Taunus) 路 Rechtsform VVaG 路 Amtsgericht Bad Homburg v. d. H. HRB 1583 路 USt.-IdNr. DE 114106814





 
Hallesche Krankenversicherung a.G.,  L枚ffelstra脽e 34-38, 70597 Stuttgart
Vors. des Aufsichtsrats: Dr. Walter Botermann 路 Vorstand: Christoph Bohn (Vors.), Dr. J眉rgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Mayer, Christian Pape,
Wiltrud Pekarek, Udo Wilcsek
Sitz Stuttgart 路 Rechtsform VVaG 路 Amtsgericht Stuttgart HRB 2686 路 USt.-IdNr. DE 147802285
Beitr盲ge zu privaten Kranken- und Pflegekrankenversicherungen unterliegen nicht der Versicherungsteuer (搂 4 Nr. 5 VersStG) 路 Versicherungsleistungen sowie Ums盲tze aus Versicherungsvertreter-/Maklert盲tigkeiten sind umsatzsteuerfrei
 



 
Die Pflichtangaben der ALH Gruppe gem盲脽 搂 35a GmbHG bzw. 搂 80 AktG finden Sie hier: https://www.alte-leipziger.de/impressum 





______________________

ALH Gruppe
Alte Leipziger-Platz 1, 61440 Oberursel
Tel.: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882
E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de
www.hallesche.de



-----Urspr眉ngliche Nachricht-----
Von: Laurenz Albe <laurenz.albe@cybertec.at>
Gesendet: Dienstag, 14. April 2026 12:58
An: Subramanian,Ramachandran IT-md-db <ramachandran.subramanian@alte-leipziger.de>; pgsql-novice@lists.postgresql.org
Betreff: Re: Executing INSERTs from a file but with a wait delay.



On Tue, 2026-04-14 at 08:17 +0000, Subramanian,Ramachandran wrote:

> Let us say that I have 10 Insert statements in a file called  run_inserts.sql .

>

> I run it with  psql -p 5432 -f run_inserts.sql.

>

>

> My wish is to find a way to execute it, but I want it to wait after each INSERT  till I hit Enter .

>

>

> I could use pg_sleep , but that is a preset value..  I want to make it wait indefinitely till I hit enter.

>

> Is this even possible?  Thank you in advance for your help.



From the psql manual:



       -s

       --single-step

           Run in single-step mode. That means the user is prompted before each command is sent to

           the server, with the option to cancel execution as well. Use this to debug scripts.



Yours,

Laurenz Albe


reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-novice@postgresql.org
  Cc: ramachandran.subramanian@alte-leipziger.de, laurenz.albe@cybertec.at, pgsql-novice@lists.postgresql.org
  Subject: Re: AW: Executing INSERTs from a file but with a wait delay.
  In-Reply-To: <42ef83b5fdad4d8787855260a39a232e@alte-leipziger.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox