serial primary key start from

Hi, I'm wondering is there a way to say to the primary key, from which value to start? I'm using postgress

id: serial('id').primaryKey()

id: serial('id').primaryKey()

1 Reply

Bozic0909OP•2d ago

i found solution https://popsql.com/learn-sql/postgresql/how-to-alter-sequence-in-postgresql

PopSQL

PostgreSQL: Alter Sequence Command - PopSQL

Learn how to use the PostgreSQL 'Reset Sequence' command. If you have auto-incrementing serial ID columns, they typically start at 1. Sequences, managed in their designated tables, store essential details like start values and last values. Use 'Alter Sequence' to change the initial ID number.

Gaming

Programming

serial primary key start from

Did you find this page helpful?