Seeking quick way to clone a row, but give it a new pk. - Mailing list 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/