PostgreSQL Sequence ์์ฑ / postgreSQL ์ํ์ค ์์ฑ
๐พDatabase/PostgreSQL
2020. 8. 31. 03:52
#์ํ์ค ์์ฑ create sequence TB_Board_SEQ start with 1 increment by 1 cache 10; #์ํ์ค ์ ๋ ฅ INSERT INTO TB_BOARD VALUES(nextval('TB_BOARD_SEQ'), ....); #์ํ์ค ์ด๊ธฐํ ALTER SEQUENCE TB_USER_SEQ RESTART WITH 1;
PostgreSQL Sequence / postgreSQL ์ํ์ค ์์ฑ / ์ถ๊ฐ / ์ด๊ธฐํ
๐พDatabase/PostgreSQL
2020. 8. 30. 01:36
#์ํ์ค ์์ฑ create sequence TB_Board_SEQ start with 1 increment by 1 cache 10; #์ํ์ค ์ถ๊ฐ INSERT INTO TB_BOARD VALUES(nextval('TB_BOARD_SEQ'), ....); #์ํ์ค ์ด๊ธฐํ ALTER SEQUENCE TB_USER_SEQ RESTART WITH 1;