Insert Table from Execute String Query

From: İlyas Derse <ilyasderse(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Insert Table from Execute String Query
Date: 2019-12-06 09:00:38
Message-ID: CALcdmyRo4=n6WTtb7NJcHAWzwJ6yDa1GhAaJkB3FGXyE9UbfXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to insert temp table from execute string query. How can I do ? I'm
trying like that but not working.

CREATE OR REPLACE FUNCTION public.testdyn
(
x integer
)
RETURNS TABLE
(
id bigint,
text character varying(4000)
)
AS $$
DECLARE mysql TEXT;
BEGIN
create temp table tmp1
(
id1 bigint,
text character varying(4000)
);
mysql = 'select id, text from TEST';

RETURN QUERY
EXECUTE mysql INTO tmp1 ;
END;
$$ LANGUAGE plpgsql;

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shalini 2019-12-06 09:26:25 Tuple concurrency issue in large objects
Previous Message Ron 2019-12-06 02:50:11 Re: Date created for tables