[GENERAL] Copy row from table to table

[Kall, Bruce A.]

What is the easiest way to copy a particular row from one table to
another (assuming all the columns are exactly the same).  I want to 
maintain a table ('backup_table') that has rows I have (or will be) 
deleting from my 'original_table'. (Both tables have the same 68 columns).

I've tried
INSERT INTO backup_table SELECT * FROM original_table WHERE id='2305'
COPY seems to only work between tables and files.
Thanks,
Bruce
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org