Shows several things about PostgreSQL: how to use multi-statement query in query window, output message and use metadata

dynamic_postgresql_command.sql

DO
$do$
declare
	r record;
	query_cmd text;
begin
	for r in select table_name from information_schema.tables where table_schema = 'public' and table_name like 'prefix%'
	loop
		query_cmd := format('delete from %s where CONDITION', r.table_name);
-- 		raise notice '%', query_cmd;
		execute query_cmd;
	end loop;
end
$do$;