INSERT INTO ... SELECT - Mailing list pgsql-sql

From Silke Trissl
Subject INSERT INTO ... SELECT
Date
Msg-id 3F376E13.7080907@informatik.hu-berlin.de
Whole thread Raw
Responses Re: INSERT INTO ... SELECT  (Jonathan Gardner <jgardner@jonathangardner.net>)
List 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 by date:

Previous
From: Benoît Bournon
Date:
Subject: Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
Next
From: proghome@silesky.com (krystoffff)
Date:
Subject: optimisation of a code