insert into table from list or array ?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: insert into table from list or array ?
Date: 2010-10-18 18:00:27
Message-ID: 4CBC8B3B.7060708@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

:)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Viktor Bojović 2010-10-18 18:12:56 Re: insert into table from list or array ?
Previous Message Rommel the iCeMAn 2010-10-16 16:23:24 Re: SIMILAR TO