Hello Guillaume Lelarge ! I suggest you try the following question:
RE-CREATE YOUR TABLES AS FOLLOW: CREATE SEQUENCE table1_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 10000000 START 1 CACHE 1; CREATE TABLE TABLE1 ( ID INTEGER NOT NULL DEFAULT nextval('table1_id_seq'::regclass) , NAME VARCHAR(200) NOT NULL ); CREATE TABLE TABLE2 ( NAME VARCHAR(200) NOT NULL ); ------------------------INSERTING THE DATA------------------------------ INSERT INTO TABLE1 (NAME) SELECT NAME FROM TABLE2; Note: The ID in Table1 will be generated automaticale because of DEFAULT nextval('table1_id_seq'::regclass) James Kitambara Computer System Analyst and Programmer Bank of Tanzania, P.O. Box 2939, Mobile : +255 71 3307632, Dar es Salaam, Tanzania. --- On Wed, 22/9/10, Guillaume Lelarge <guilla...@lelarge.info> wrote: From: Guillaume Lelarge <guilla...@lelarge.info> Subject: Re: [SQL] insert into help To: "Nicholas I" <nicholas.domni...@gmail.com> Cc: pgsql-sql@postgresql.org Date: Wednesday, 22 September, 2010, 8:35 Le 22/09/2010 09:32, Nicholas I a écrit : > Hi, > > i have two tables, > --------------------------------------------------------------- > *table1 > > id type serial, name varchar;* > *-------------------------------------------------------------- > table 2 > > name varchar;* > --------------------------------------------------------------- > > i want to insert the values of table 2 into table 1, with automatic id's. > > insert into table1(select * from table2); > > is not working, how can i append the data to table 1 with auto incremented > or nextval. > INSERT INTO table1 (name) SELECT name FROM table2; -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql