moving content of a table to another table - Mailing list pgsql-novice

From roy simkes
Subject moving content of a table to another table
Date
Msg-id BAY108-W20111570F6D46CA92A012A13F0@phx.gbl
Whole thread Raw
Responses Re: moving content of a table to another table  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: moving content of a table to another table  ("Phillip Smith" <phillips@weatherbeeta.com.au>)
List pgsql-novice
 
 
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
 
Thanks.


Use Messenger to talk to your IM friends, even those on Yahoo! Talk now!

pgsql-novice by date:

Previous
From: "Jasbinder Bali"
Date:
Subject: Re: [GENERAL] Version 1 Calling convention
Next
From: "A. Kretschmer"
Date:
Subject: Re: moving content of a table to another table