plpgsql - Postgresql CREATE TABLE AS INSERT RETURNING -


i trying perform like

create temp table tblname (   insert tbl2 select(1,1) returning a,b  ); 

but i've got error: syntax error @ or near "insert";

is possible combine create table select , insert select returning clauses?

create temp table tblname     (         insert tbl2 (a, b)         select 1, 1         returning a,b      )     select a, b     

Comments

Popular posts from this blog

c# - How to get the current UAC mode -

postgresql - Lazarus + Postgres: incomplete startup packet -

javascript - Ajax jqXHR.status==0 fix error -