Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Moore
Subject Re: insert values from a ROW object
Date
Msg-id CACpWLjMqxPikwWF+gYb8xa3birV9aJnek6qhW1d8-LHvDrYUSg@mail.gmail.com
Whole thread Raw
In response to insert values from a ROW object  (Michael Moore <michaeljmoore@gmail.com>)
List pgsql-sql
Tree view
by the way, the row structure of temp_rslt and final_rslt are identical.


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?

TIA
Mike

pgsql-sql by date:

Previous
From: Michael Moore
Date:
Subject: insert values from a ROW object
Next
From: "David G. Johnston"
Date:
Subject: Re: insert values from a ROW object