How in procedure to write down array of row of the temporary table in var?

Question

PostgreSQL

Hello.
In a procedure (postgreSQL) I create a temporary table with a random name, from which I then want to select and put the data into a variable.

DECLARE
    temp_table_name TEXT;
    temp_table_records RECORD[]; -- знаю, это не корректно, но как будет правильно?
BEGIN
SELECT INTO temp_table_name CONCAT('temp_manager_operative', floor(random()*(999999-100000)+100000)); -- генерация случайного имени таблицы

EXECUTE 'CREATE TEMP TABLE IF NOT EXISTS ' || temp_table_name || ' (id INT, name TEXT)'; -- создаем временную таблицу

 EXECUTE 'SELECT * FROM ' || temp_table_name INTO temp_table_records ; -- выполняем sql запрос во временную таблицу и кладем результат в переменную

Can you please clarify how you can put the result into a variable without using type creation?
Thank you!

Answer 1

First, why do you need a temporary table?
Secondly, what do you plan to do next?
In the abstract case - it looks like you are trying to invent a cursor www.postgresql.org/docs/current/static/plpgsql-cur...