moving content of a table to another table

Поиск
Список
Период
Сортировка
От roy simkes
Тема moving content of a table to another table
Дата
Msg-id BAY108-W20111570F6D46CA92A012A13F0@phx.gbl
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "Jasbinder Bali"
Дата:
Сообщение: Re: [GENERAL] Version 1 Calling convention
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: moving content of a table to another table