public inbox for pgsql-novice@postgresql.org
help / color / mirror / Atom feedExecuting INSERTs from a file but with a wait delay.
3+ messages / 2 participants
[nested] [flat]
* Executing INSERTs from a file but with a wait delay.
@ 2026-04-14 08:17 Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
2026-04-14 10:58 ` Re: Executing INSERTs from a file but with a wait delay. Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 3+ messages in thread
From: Subramanian,Ramachandran @ 2026-04-14 08:17 UTC (permalink / raw)
To: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Hello,
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.
LG
Ram
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Executing INSERTs from a file but with a wait delay.
2026-04-14 08:17 Executing INSERTs from a file but with a wait delay. Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
@ 2026-04-14 10:58 ` Laurenz Albe <laurenz.albe@cybertec.at>
2026-04-14 11:04 ` AW: Executing INSERTs from a file but with a wait delay. Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
0 siblings, 1 reply; 3+ messages in thread
From: Laurenz Albe @ 2026-04-14 10:58 UTC (permalink / raw)
To: Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>; pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* AW: Executing INSERTs from a file but with a wait delay.
2026-04-14 08:17 Executing INSERTs from a file but with a wait delay. Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
2026-04-14 10:58 ` Re: Executing INSERTs from a file but with a wait delay. Laurenz Albe <laurenz.albe@cybertec.at>
@ 2026-04-14 11:04 ` Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
0 siblings, 0 replies; 3+ messages in thread
From: Subramanian,Ramachandran @ 2026-04-14 11:04 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2026-04-14 11:04 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-04-14 08:17 Executing INSERTs from a file but with a wait delay. Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
2026-04-14 10:58 ` Laurenz Albe <laurenz.albe@cybertec.at>
2026-04-14 11:04 ` AW: Executing INSERTs from a file but with a wait delay. Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox