PostgreSQL创建表格作为插入返回

Question

我想要执行类似于以下内容的操作

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

但是我收到了错误提示：ERROR: syntax error at or near "INSERT";

是否可以结合CREATE TABLE AS SELECT和INSERT FROM SELECT RETURNING子句？

- alexglue

---

无关的，但是：在“create table as”语句中不需要将“select”语句放在括号中。 - user330315

Answer 1

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

- Clodoaldo Neto