insert values from a ROW object

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: insert values from a ROW object
Date: 2016-09-22 21:42:56
Message-ID: CACpWLjMR2-1XOMd7y6WbHribWUvNrxq42jxeDbv7CVsve1H9CQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Moore 2016-09-22 21:44:07 Re: insert values from a ROW object
Previous Message Tom Lane 2016-09-20 14:47:50 Re: PostgreSQL 9.5 operator precedence