Insert INTO Temp Table result of dynamic query in PostgreSQL

Question

I am trying to write an SQL Server stored procedure in PostgreSQL. One of the statement is, INSERT INTO @TempTable EXEC(@DynamicQuery) In SQL Server, @DynamicQuery executes and inserts result into @TempTable table variable. I am not finding similar option in PostgreSQL. Can somebody help with any hint please. Thanks.

HINT: create table as

Gordon Linoff
– Gordon Linoff

2017-01-13 13:08:01 +00:00
Commented Jan 13, 2017 at 13:08 — Gordon Linoff
– Gordon Linoff, Commented Jan 13, 2017 at 13:08
Will it work with dynamic query with EXECUTE()?

kaushalparik27
– kaushalparik27

2017-01-13 13:10:48 +00:00
Commented Jan 13, 2017 at 13:10 — kaushalparik27
– kaushalparik27, Commented Jan 13, 2017 at 13:10

Laurenz Albe · Accepted Answer · 2017-01-13 13:27:20Z

7

Your PL/pgSQL line would look similar to the following:

EXECUTE 'CREATE TEMPORARY TABLE mytemp AS ' || dynamicquery;

answered Jan 13, 2017 at 13:27

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert INTO Temp Table result of dynamic query in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related