Re: insert into help

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 <guillaume(at)lelarge(dot)info> wrote:

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Subject: Re: [SQL] insert into help
To: "Nicholas I" <nicholas(dot)domnic(dot)i(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)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