postgresql insert from select
Sale Price:$333.00
Original Price:$999.00
sale
I need to copy records within the same table changing only one field. My table has default-generated sequence entry_id_seq, however I am not sure id column is SERIAL (how to check that?). \d tab r... insert live
Quantity: