Announcement

Collapse
No announcement yet.

PostgreSQL Table Auto Increment setting

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • PostgreSQL Table Auto Increment setting

    I’m running the trial version of Navicat Premium 11.0 Mac. I created a table with 4 columns. And now, I want to add an auto increment column. But, I can’t find how to do it. Any ideas?

  • #2
    To create an auto-increment field, please add a serial field. In table designer, you can define "serial" data type when you create a new table or add a new column to an existing table. For more details on serial type, please refer to the postgresql manual at http://www.postgresql.org/docs/curre...ATATYPE-SERIAL

    Comment

    Working...
    X