From: James Kitambara <jameskitambara@yahoo.co.uk>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: insert into help
Date: Fri, 24 Sep 2010 09:37:21 +0000 (GMT)
Message-ID: <474252.7907.qm@web27908.mail.ukl.yahoo.com> (raw)
In-Reply-To: <4C99B1B8.6040607@lelarge.info>
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@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;
--
Guillaume
http://www.postgresql.frhttp://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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jameskitambara@yahoo.co.uk, guillaume@lelarge.info
Subject: Re: insert into help
In-Reply-To: <474252.7907.qm@web27908.mail.ukl.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox