Skip site navigation (1)
Skip section navigation (2)
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!
Peripheral Links
Header And Logo
|
Site Navigation
moving content of a table to another table
- From: "roy simkes" <roysimkes(at)hotmail(dot)com>
- To: pgsql-novice(at)postgresql(dot)org
- Subject: moving content of a table to another table
- Date: Thu, 31 Aug 2006 13:05:10 +0000
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!
- Follow-Ups:
- Re: moving content of a table to another table
- From: Phillip Smith
- Re: moving content of a table to another table
- From: A. Kretschmer
- Re: moving content of a table to another table
- Prev by Date: Re: [GENERAL] Version 1 Calling convention
- Next by Date: Re: moving content of a table to another table
- Previous by thread: Version 1 Calling convention
- Next by thread: Re: moving content of a table to another table
- Indexes: