CODEWITHSUNDEEP
postgresqlplpgsqlcreate-tablesql-returning
alexglue
alexglue

Reputation: 1322

Postgresql CREATE TABLE AS INSERT RETURNING

I trying to perform something like

CREATE TEMP TABLE tblname AS (
  INSERT INTO tbl2 FROM SELECT(1,1) RETURNING a,b 
);

but i've got ERROR: syntax error at or near "INSERT";

Is it possible to combine CREATE TABLE AS SELECT and INSERT FROM SELECT RETURNING clauses?

Upvotes: 5

Views: 2264

Answers (1)

Clodoaldo Neto
Clodoaldo Neto

Reputation: 125244

create temp table tblname as
    with i as (
        insert into tbl2 (a, b)
        select 1, 1
        returning a,b 
    )
    select a, b
    from i

Upvotes: 14

Related Questions