Create Auto inc fields

[guxx]

Hello

how do i create a migration with an integer field auto_incremental ? This field won't be the id or key.

[de-perotti]

I think you might want to have a look at this https://www.geeksforgeeks.org/sql-sequences/

[sio4]

There could be several approaches to achieve it.

1. Of course, the simplest way with the current version of Fizz could be using sql() so you can run your own SQL.
2. Supporting a user-defined option (e.g. custom or constraint) could be one option. currently, only a few options are supported.
   • https://github.com/gobuffalo/fizz#supported-options
   • e.g. t.Column("my_col", "int", {"custom": "GENERATED ALWAYS AS IDENTITY"})
3. Adding auto_increment option could also be an option but I am not sure how many developers need it

I would like to postpone this to the next version.