0

"SERIAL" type does not exist yet, so how can we do the basic auto increment field in DBeaver 21.O via his GUI ?

Chenille33
  • 93
  • 1
  • 1
  • 10
  • `serial` is somewhat discouraged to begin with, you should use an `identity` column anyways: `create table foo (id integer generated always as identity)` - but `create table foo (id serial)` should work just fine regardless of the SQL client –  Jun 01 '21 at 15:06
  • Does this answer your question? [How to create auto incrementing / SERIAL id column's on DBeaver using PostgreSQL?](https://stackoverflow.com/questions/52177610/how-to-create-auto-incrementing-serial-id-columns-on-dbeaver-using-postgresql) – nbk Jun 01 '21 at 15:07
  • @nbk : no because the solution gived is about the famous serial type which does not exist anymore.... But thanks. – Chenille33 Jun 01 '21 at 15:11
  • @a_horse_with_no_name I speak with DBeaver GUI but thanks also. – Chenille33 Jun 01 '21 at 15:11
  • You should be creating your tables through SQL scripts that are stored in Git, properly managed with a schema migration tool. Don't use a GUI for that. –  Jun 01 '21 at 15:12
  • serial is int(4) in dbbeaver and since 2017 they didn't find a good solution, make what @a_horse_with_no_name said, or use another tool – nbk Jun 01 '21 at 16:07

1 Answers1

1

You can set "serial" as data type with DBeaver GUI

serialViaDBeaver

And why serial type does not exist yet? I can see it in documentation

LonWo
  • 321
  • 1
  • 8