So I am trying to run this function. CREATE OR REPLACE FUNCTION TableIteration() RETURNS TABLE(table_schema text, table_name text) LANGUAGE plpgsql AS $$ DECLARE tgt_schema varchar; list text[] := ARRAY[ "text1", "text2", "text3", "text4", "text5", "text6", "text7", "text8", "text9" ]; BEGIN FOREACH tgt_schema IN ARRAY list LOOP RETURN QUERY EXECUTE ‘SELECT t.table_schema :: text, t.table_name::text from… Read More Concatenation with variable in function gives an error