Postgres Pro
Downloads
Home   >   mailing lists

Re: insert values from a ROW object - Mailing list pgsql-sql

From David G. Johnston
Subject Re: insert values from a ROW object
Date
Msg-id CAKFQuwbzAMbooJ+vdUb+1gxNO-sWbNFk16HQ5LNGG0X3dJXhKA@mail.gmail.com
Whole thread Raw
In response to insert values from a ROW object  (Michael Moore <michaeljmoore@gmail.com>)
Responses Re: insert values from a ROW object
List pgsql-sql
Tree view
On Thu, Sep 22, 2016 at 2:42 PM, Michael Moore <michaeljmoore@gmail.com> wrote:
for a in select * from temp_rslt
loop
   insert into final_rslt select row(a.*);
end loop;

I want to do something like the above. I don't want to have to name each 'a.' variable.
Is it possible?


INSERT INTO final_rslt VALUES ( (a).* );

David J.

pgsql-sql by date:

Previous
From: Michael Moore
Date:
Subject: Re: insert values from a ROW object
Next
From: Thomas Kellerer
Date:
Subject: Re: insert values from a ROW object