postgres get next sequence value code example

Example 1: postgresql define pk sequence next number

ALTER SEQUENCE serial RESTART WITH 105;

Example 2: getting next sequence value jpa postgress

@Query(value = "SELECT nextval('item_id_seq')", nativeQuery =
            true)
    Long getNextSeriesId();