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:
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
Last activity: Feb 26, 2024, 10:50 PM