/* Exemple avec une table table_test existante ayant un champ geom */
DROP SEQUENCE IF EXISTS serial_arret;
CREATE SEQUENCE serial_arret START WITH 4000;

SELECT b.geom,
       nextval('serial_arret') as num
FROM table_test as b