Auto-increment with PostgreSQL

eraser · May 5, 2009, 8:53am

Hi,

I’d like to know how to set a column in a ERM to auto-increment using PostgreSQL. I didn’t find any proper thing.

Thanks a lot.

Regards,
Eraser

LilianWong · May 5, 2009, 3:34pm

Hi Eraser,

Thanks for your post. By default (“native” in ID Generator) it’s auto-increment already.

Best regards,
Lilian Wong

default_ID_Generator.png

Anonymous · September 18, 2012, 9:28am

And with the SqLite? ID Generator as “native” does not make the field as autoincrement on the SqLite database.

Anonymous · August 8, 2014, 9:21am

The ID Generator “native” works in SQLite and Postgres. Did you try to “reload” after saving a record?