반응형 ALWAYS AS1 [PostgreSQL] 자동증가 방법 Postgresql 자동 증가 Sequence Serial GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY Sequence 생성 CREATE SEQUENCE tn_user_id_seq; 테이블 생성 CREATE TABLE tn_user_seq ( id BIGINT NOT NULL DEFAULT NEXTVAL('tn_user_id_seq') PRIMARY KEY, name VARCHAR(255), created_date TIMESTAMP, modified_date TIMESTAMP ); Sequence 수정 ALTER SEQUENCE tn_user_id_seq OWNED BY tn_user_seq.id; 테스트 생성 INSERT INTO tn_user_seq (name, .. 2021. 7. 25. 이전 1 다음 반응형
