run multiple function selects postgres

Question

I need to run a remove_user function 1000s of times in single postgres query with a different values. I have created the statements.

Currently If I select all still only executes first line. I am using PGadmin.

SELECT public.remove_user(56);
SELECT public.remove_user(57);
SELECT public.remove_user(58);
SELECT public.remove_user(59);
SELECT public.remove_user(60);
SELECT public.remove_user(61);

user1822 · Accepted Answer · 2023-01-20 17:36:19Z

1

That sounds more like a pgAdmin problem, than a Postgres problem.

But if pgAdmin can't run set of statements, then you can rewrite that to a single statement:

select public.remove_user(id)
from ( 
   values (56), (57), (58), (59), (60), (61)
) as x(id);

answered Jan 20, 2023 at 17:36

user1822

Agreed this should of worked but your solution worked well now RSI adverted

icecurtain
– icecurtain

2023-01-20 18:06:08 +00:00
Commented Jan 20, 2023 at 18:06

Add a comment |

Stack Exchange Network

run multiple function selects postgres

1 Answer 1

Your Answer

Hot Network Questions

run multiple function selects postgres

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions