728x90
반응형
ALTER TABLE a_table
ALTER COLUMN a_seq
ADD GENERATED BY DEFAULT AS IDENTITY
( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ) ;
728x90
'IT story > db' 카테고리의 다른 글
| [postgresql] upsert문(merge문) (0) | 2022.09.26 |
|---|---|
| [ORACLE] [POSTGRESQL] oracle to postgresql (0) | 2021.08.24 |