CODE EXAMPLE FOR SQL

auto increment in postgresql

ALTER TABLE temp ALTER COLUMN id
  ADD GENERATED BY DEFAULT AS IDENTITY