Greetings -- I have a huge table of the form
(integer,integer,smallint,date). Its origin is an ASCII file which I
load with \copy. Now I want to number the rows, adding an id column
as an autoincrement from a sequence. How should I do the import now
for the sequence to work -- should I add the id column last, so it
will not be filled by copy and presumably autoincrement?
Or, once the table is already in, can I add a column and force it to
be filled with consecutive numbers, effectively numbering the rows?
Cheers,
Alexy