Seeking quick way to clone a row, but give it a new pk.

Поиск
Список
Период
Сортировка
От Bryce Nesbitt
Тема Seeking quick way to clone a row, but give it a new pk.
Дата
Msg-id 45CA50E6.6090006@obviously.com
обсуждение исходный текст
Ответы Re: Seeking quick way to clone a row, but give it a new pk.  (Philip Hallstrom <postgresql@philip.pjkh.com>)
Re: Seeking quick way to clone a row, but give it a new pk.  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: Seeking quick way to clone a row, but give it a new pk.  (John DeSoi <desoi@pgedit.com>)
Список pgsql-sql
I need to create some nearly identical copies of rows in a complicated
table.

Is there a handy syntax that would let me copy a existing row, but get a
new primary key for the copy?  I'd then go in an edit the 1 or 2
additional columns that differ.  The duplicate would be in the same
table as the original.

This would save me a bunch of typing.  Can it be done?

----

Visit http://www.obviously.com/




В списке pgsql-sql по дате отправления:

Предыдущее
От: "Jan Muszynski"
Дата:
Сообщение: Re: interval as hours or minutes ?
Следующее
От: Greg Wittel
Дата:
Сообщение: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression