/* PostgreSQL Work with sequence */ :::1. Create new sequence | SergeyGurin

/*
PostgreSQL
Work with sequence
*/

:::1. Create new sequence
CREATE SEQUENCE guest_engine.store_location_hours_of_operation_id_seq;

:::2. Test sequence
select nextval('guest_engine.store_location_hours_of_operation_id_seq'::regclass);

:::3. Reset sequence
ALTER SEQUENCE guest_engine.store_location_hours_of_operation_id_seq RESTART WITH 1;