How do I initilaize a serial field during an import?
I have a script file which deletes all records in my table followed by another script file which imports fresh data into my table.
One of the fields in the table is defined as a serial field.
When I import fresh data into my table, I need this serial field to start at 1 and increment by 1 for each record that follows. It works for the initial import.
But if I delete all records and import a new set of data, it increments the serial field starting with 1 more than the last record that I just deleted.
I need a way for the serial field to start at 1 everytime I import a new set of data.