INSERT INTO ... SELECT

Поиск
Список
Период
Сортировка
От Silke Trissl
Тема INSERT INTO ... SELECT
Дата
Msg-id 3F376E13.7080907@informatik.hu-berlin.de
обсуждение исходный текст
Ответы Re: INSERT INTO ... SELECT
Список pgsql-sql
Hi,

I would like to insert into a table values from a table and user defined 
ones. Here is the example:

I found this statement to insert values from another table:

INSERT INTO test_table (cust_id, cust_name) SELECT id, name from CUSTOMER;

But the test_table has another column, which should have the same value 
for all the customers.

Is there something like

INSERT INTO test_table (int_id, cust_id, cust_name) '1', SELECT id, name 
from CUSTOMER:

and if so, what ist the correct statement? If not, what is an 
alternative to insert a single row at a time?

Thanks in advance

Silke



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

Предыдущее
От: Benoît Bournon
Дата:
Сообщение: Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
Следующее
От: proghome@silesky.com (krystoffff)
Дата:
Сообщение: optimisation of a code