Auto increment ID

Hi all !

I have a Table that does not have auto increment on the ID column.
But I do want it to auto increment...
I tried to add a default value but it won't let me.
Any idea what I should do ?

try default value without the quotes: Locations_ID_seq

heres a pic of it working for a table i have named openai_assistants:
image

i think the format is: tableName_fieldName_seq

1 Like

I think the Quotes are needed because my table has a Uppercase letter !
Either way it does not work... I think i'll just delete the Table and recreate it.

thank you !