Categories
Database Development

Add auto increment to already existing column PostgreSQL

I have a database schema of the following table: database=# \d person Table "public.person" Column | Type | Modifiers ————-+———————–+———– person_id | smallint | not null fname | character varying(20) | lname | character varying(20) | eye_color | color_enum | birth_date | date | street | character varying(30) | city | character varying(20) | state […]