Execute SQL queries stored in a table

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;
$$;

posted about 1 month ago

CC BY-SA 4.0

talex‭

129 reputation 7 1 20 12