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
