To: pgsql-sql@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: insert values from a ROW object
Date: Fri, 23 Sep 2016 00:20:22 +0200
Lines: 21
Message-ID: <ns1lg6$hir$1@blaine.gmane.org>
References: 
 <CACpWLjMR2-1XOMd7y6WbHribWUvNrxq42jxeDbv7CVsve1H9CQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21)
 Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
In-Reply-To: 
 <CACpWLjMR2-1XOMd7y6WbHribWUvNrxq42jxeDbv7CVsve1H9CQ@mail.gmail.com>
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Michael Moore schrieb am 22.09.2016 um 23:42:
> 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?
>

No need for a loop:

   insert into final_rsl
   select *
   from tmp_rslt;

This assumes that both table define the columns in the exact same order


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql