Is it possible to change an existing field to a sequence?
I have a field that contains ID numbers and I want this field to
autoincrement evrytime a new row is inserted.
The existing field is int8, (this database has been imported to
Postgresql using DBTools import wizard.)
Do I need to drop the existing column and create a new one using create
sequence.....?
and then I can use the nextval() in the insert query?
thanks
Bob