Sample Header Ad - 728x90

How can I change an existing type from "bigint" to "bigserial"?

7 votes
2 answers
28028 views
I have a PostgreSQL table with the following structure: enter image description here I simply need to change the TYPE of prove_identity_id from bigint to bigserial. I read the docs but wasn't able to understand how to legally achieve the change without the following error: PostgreSQL said: type "bigserial" does not exist PostgreSQL 10.1 on x86_64-apple-darwin14.5.0, compiled by Apple LLVM version 7.0.0 (clang-700.1.76), 64-bit
Asked by Dave Chambers (175 rep)
Jan 2, 2018, 03:02 PM
Last activity: Feb 26, 2024, 10:50 PM