Re: moving content of a table to another table

am Thu, dem 31.08.2006, um 13:05:10 +0000 mailte roy simkes folgendes:
>
>
> Hi,
>
> I'm curious if there is a way to move content of a table to another table? I do
> not like to create lot's of insert commands and then delete them. I'm sure
> there is an easy way to do this. But I would also like to know if there can be
> any problem with a coloumn type of serial. While moving the tables pgsql will
> change the serial to the next value of the sequence or will it leave as it is,
> and when I reach hat number I will have a problem about duplicate entry

You can do something like this:

test=# create table tab1 (id serial, name text);
NOTICE: CREATE TABLE will create implicit sequence "tab1_id_seq" for serial column "tab1.id"
CREATE TABLE
test=*# insert into tab1 values(default, 'andreas');
INSERT 0 1
test=*# insert into tab1 values(default, 'anja');
INSERT 0 1
test=*# create table tab2(id serial, name text);
NOTICE: CREATE TABLE will create implicit sequence "tab2_id_seq" for serial column "tab2.id"
CREATE TABLE
test=*# insert into tab2 (name) select name from tab1;
INSERT 0 2

HTH, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net