::text(1)

• PostgreSQl 시퀀스에 lpad 적용하기

  SELECT LPAD(NEXTVAL('my_sequence')::TEXT, 5, '0') AS padded_value;

  2024.12.26