Internally, Postgres generates a sequence for both serial and identity columns, using the convention <table_name>_<column_name>_seq. But the way it manages these sequences is where things get interesting. We'll uncover these differences as we explore the issues with serial and how identity columns solve them.

continue reading on www.naiyerasif.com

⚠️ This post links to an external website. ⚠️