Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
I manage to solve my problem with next code: do $$ declare sql_text text; sql_list text[]; begin sql_list := array( select c.sql_text from sql_command c ); raise notice 'sta...
Answer
#1: Initial revision
by
talex
·
2024-09-06T10:41:08Z (3 months ago)
I manage to solve my problem with next code:
```
do $$
declare
sql_text text;
sql_list text[];
begin
sql_list := array(
select
c.sql_text
from
sql_command c
);
raise notice 'start';
for sql_text in select unnest(sql_list)
loop
raise notice '%', sql_text;
execute sql_text;
end loop;
raise notice 'end';
end;
$$;
```
It can be simplified. I use intermediate variable `sql_list` because I have pretty complex `select` that generates `sql`.
Simplified version:
```
do $$
declare
sql_text text;
begin
for sql_text in (select c.sql_text from sql_command c)
loop
execute sql_text;
end loop;
end;
$$;
```