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 <guillaume@lelarge.info> wrote:
From: Guillaume Lelarge <guillaume@lelarge.info> Subject: Re: [SQL] insert into help To: "Nicholas I" <nicholas.domnic.i@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;