insert into table from list or array ?

Поиск
Список
Период
Сортировка
От Andreas
Тема insert into table from list or array ?
Дата
Msg-id 4CBC8B3B.7060708@gmx.net
обсуждение исходный текст
Ответы Re: insert into table from list or array ?  (Viktor Bojović <viktor.bojovic@gmail.com>)
Re: insert into table from list or array ?  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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.

:)


В списке pgsql-sql по дате отправления:

Предыдущее
От: Rommel the iCeMAn
Дата:
Сообщение: Re: SIMILAR TO
Следующее
От: Viktor Bojović
Дата:
Сообщение: Re: insert into table from list or array ?