Message-ID: <4CBC8B3B.7060708@gmx.net>
Date: Mon, 18 Oct 2010 20:00:27 +0200
From: Andreas <maps.on@gmx.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de;
	rv:1.9.2.9) Gecko/20100915 Thunderbird/3.1.4
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: insert into table from list or array ?
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

  Hi,

is it possible to insert into a table from list or an array ?

Suppose there is a set of numbers that might be IDs of tables within the DB.
To work with them I'd need a temporary table that just holds a single 
column with those numbers.
Something like

create temporary table tmptable as select id from
( 2, 3, 5, 7, 11, 13, 17, 19, 23, 31,
   37, ... );

would be great.

I get those numbers as textfile with 10 numbers per line and devided by 
comma+space as in the sample above, though the comma+space is negotiable 
if this were an issue.

:)