PostgreSQL UUID 생성

create extension pgcrypto; /*설치*/

SELECT GEN_RANDOM_UUID()
     , UPPER(REPLACE(GEN_RANDOM_UUID()::VARCHAR, '-', ''))
  FROM GENERATE_SERIES(1, 3);
  
SELECT TO_CHAR('000079' + id, 'FM000000')
  FROM GENERATE_SERIES(1, 34) id