繝�ヵ繧ｩ繝ｫ繝亥､縲√す繝ｼ繧ｱ繝ｳ繧ｹ縲ヾERIAL蝙�

繝�ヵ繧ｩ繝ｫ繝亥､

INSERT縺ｧ謖�ｮ壹＠縺ｪ縺九▲縺溷�縺ｯ騾壼ｸｸNULL縺ｫ縺ｪ繧九′縲√≠繧区ｱｺ縺ｾ縺｣縺溷､縲√∪縺溘�髢｢謨ｰ縺ｮ螳溯｡檎ｵ先棡縺ｪ縺ｩ縺ｫ縺吶ｋ縺薙→縺後〒縺阪ｋ縲�
縺薙ｌ繧�繝�ヵ繧ｩ繝ｫ繝亥､縺ｨ縺�≧縲�

蛻怜錐 蝙擬 蛻ｶ邏Ь[ DEFAULT 繝�ヵ繧ｩ繝ｫ繝亥､];

谺｡縺ｮ�ｳ�ｱ�ｬ繧偵ヵ繧｡繧､繝ｫ縺ｨ縺励※菴懈�縲ゑｼ�default041.sql��

繝ｭ繧ｰ繧､繝ｳ逕ｻ髱｢縺九ｉ螳溯｡後�

oddtbs=> \i default041.sql
...
oddtbs=> insert into emp (code, name) values(564001, '驤ｴ譛ｨ鄒ｩ逕ｷ');
INSERT 0 1
oddtbs=> insert into emp (code, name, gender, age) values(564002, '譁手陸豢句ｭ�', 2, 30);
INSERT 0 1
oddtbs=> select * from emp;
  code  |   name   | gender | age |  hiredate
--------+----------+--------+-----+------------
 564001 | 驤ｴ譛ｨ鄒ｩ逕ｷ |      1 |  22 | 2009-08-12
 564002 | 譁手陸豢句ｭ� |      2 |  30 | 2009-08-12
(2 rows)

窶ｻ 謖�ｮ壹＠縺ｪ縺九▲縺溷�縺ｯ繝�ヵ繧ｩ繝ｫ繝亥､縺ｫ縺ｪ縺｣縺ｦ縺�ｋ縺薙→縺檎｢ｺ隱阪〒縺阪ｋ縲�

繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ竭�

繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ縺ｨ縺ｯ逡ｪ蜿ｷ繧堤ｮ｡逅�＠縺ｦ逋ｺ陦後☆繧九が繝悶ず繧ｧ繧ｯ繝医〒縺ゅｋ縲�

CREATE SEQUENCE 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ蜷�;

繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ縺ｯCURRVAL繧НEXTVAL縺ｪ縺ｩ縺ｮ髢｢謨ｰ縺ｧ菴ｿ逕ｨ縺吶ｋ縲�
CURRVAL縺ｯ迴ｾ蝨ｨ縺ｮ蛟､繧貞叙蠕励☆繧九�
縺溘□縺励√◎縺ｮ繧ｻ繝�す繝ｧ繝ｳ縺ｧNEXTVAL繧貞ｮ溯｡後＠縺ｦ縺�↑縺��ｴ蜷医，URRVAL縺ｯ繧ｨ繝ｩ繝ｼ縺ｨ縺ｪ繧九�
NEXTVAL縺ｯ谺｡縺ｮ蛟､繧貞叙蠕励☆繧九�
縺ｪ縺翫√％縺薙°繧峨�\t縺ｧ陦ｨ遉ｺ蠖｢蠑上ｒ螟画峩縺励※縺翫￥縲�

oddtbs=> \t
Showing only tuples.
oddtbs=> create sequence seq;
CREATE SEQUENCE
oddtbs=> select currval('seq');
ERROR:  currval of sequence "seq" is not yet defined in this session
窶ｻ NEXTVAL繧貞ｮ溯｡後＠縺ｦ縺�↑縺��縺ｧ繧ｨ繝ｩ繝ｼ縲�
oddtbs=> select nextval('seq');
       1
oddtbs=> select currval('seq');
       1
oddtbs=> select nextval('seq');
       2
oddtbs=> select currval('seq');
       2

繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ竭｡

隍�尅縺ｪ繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧貞ｮ夂ｾｩ縺吶ｋ縺薙→繧ゅ〒縺阪ｋ縲�

CREATE SEQUENCE 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ蜷� START 蛻晄悄蛟､ INCREMENT 蠅怜� MINVALUE 譛蟆丞､ MAXVALUE 譛螟ｧ蛟､ [CYCLE];

CYCLE謖�ｮ壹☆繧九→縲∵怙螟ｧ蛟､縺ｾ縺溘�譛蟆丞､繧偵�縺ｿ蜃ｺ縺吝�ｴ蜷医↓縲∵怙蟆丞､縺ｾ縺溘�譛螟ｧ蛟､縺ｫ縺ｪ繧翫∝､縺悟ｾｪ迺ｰ縺吶ｋ縲�
謖�ｮ壹＆繧後↑縺代ｌ縺ｰ縲√�縺ｿ蜃ｺ縺吶→縺阪↓繧ｨ繝ｩ繝ｼ縺ｨ縺ｪ繧九�

oddtbs=> drop sequence seq;
DROP SEQUENCE
oddtbs=> create sequence seq start 2000 increment 10 minvalue 1000 maxvalue 2050 cycle;
CREATE SEQUENCE
oddtbs=> select nextval('seq');
    2000
oddtbs=> select nextval('seq');
    2010
oddtbs=> select nextval('seq');
    2020
oddtbs=> select nextval('seq');
    2030
oddtbs=> select nextval('seq');
    2040
oddtbs=> select nextval('seq');
    2050
oddtbs=> select nextval('seq');
    1000
窶ｻ 譛螟ｧ蛟､繧定ｶ�∴縺ｦ縺励∪縺��縺ｧ譛蟆丞､縺ｫ縺ｪ縺｣縺溘�
oddtbs=> select nextval('seq');
    1010
oddtbs=> select nextval('seq');
    1020

繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧偵ョ繝輔か繝ｫ繝亥､縺ｧ菴ｿ逕ｨ縺吶ｋ

遉ｾ蜩｡繝��繝悶Ν縺ｮ遉ｾ蜩｡逡ｪ蜿ｷ縺ｪ縺ｩ縺ｯ縲∝ｮ滄圀縺ｫ莠ｺ髢薙′謇句虚縺ｧ蛟､繧呈ｱｺ繧√ｋ縺ｮ縺碁屮縺励＞蝣ｴ蜷医ｂ縺ゅｋ縲�
縺昴�蝣ｴ蜷医√す繝ｼ繧ｱ繝ｳ繧ｹ繧偵ョ繝輔か繝ｫ繝亥､縺ｨ邨�∩蜷医ｏ縺帙ｋ縺薙→縺ｧ隗｣豎ｺ縺ｧ縺阪ｋ縲�
縺ｪ縺翫√％縺薙°繧芽｡ｨ遉ｺ蠖｢蠑上�蜈�↓謌ｻ縺吶�

谺｡縺ｮ�ｳ�ｱ�ｬ繧偵ヵ繧｡繧､繝ｫ縺ｨ縺励※菴懈�縲ゑｼ�default042.sql��

oddtbs=> \t
Tuples only is off.
oddtbs=> \i default042.sql
...
oddtbs=> insert into emp (name, gender, age) values('驤ｴ譛ｨ鄒ｩ逕ｷ', 1, 58);
INSERT 0 1
oddtbs=> insert into emp (name, gender, age) values('譁手陸豢句ｭ�', 2, 30);
INSERT 0 1
oddtbs=> select * from emp;
  code  |   name   | gender | age |  hiredate
--------+----------+--------+-----+------------
 564001 | 驤ｴ譛ｨ鄒ｩ逕ｷ |      1 |  58 | 2009-08-12
 564002 | 譁手陸豢句ｭ� |      2 |  30 | 2009-08-12
(2 rows)

窶ｻ code蛻励′閾ｪ蜍慕噪縺ｫ蜑ｲ繧頑険繧峨ｌ縺ｦ縺�ｋ縲�

SERIAL蝙�

SERIAL縺ｨ縺�≧迚ｹ谿翫↑蝙九ｒ菴ｿ逕ｨ縺吶ｋ縺ｨ縲∬�蜍慕噪縺ｫ荳願ｨ倥�繧医≧縺ｪ繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ菴懈�縺ｨ繝�ヵ繧ｩ繝ｫ繝亥､險ｭ螳壹ｒ陦後≧縲�
縺溘□縺励√す繝ｼ繧ｱ繝ｳ繧ｹ縺ｮ諤ｧ雉ｪ縺ｫ髢｢縺吶ｋ邏ｰ縺九＞謖�ｮ壹�縺ｧ縺阪★縲�ｼ代°繧蛾幕蟋九＠縺ｦ�代▽縺･縺､蠅励∴繧九�

谺｡縺ｮ�ｳ�ｱ�ｬ繧偵ヵ繧｡繧､繝ｫ縺ｨ縺励※菴懈�縲ゑｼ�serial041.sql��

繝ｭ繧ｰ繧､繝ｳ逕ｻ髱｢縺九ｉ螳溯｡後�

oddtbs=> \i serial041.sql
...
oddtbs=> insert into emp (name, gender, age) values('驤ｴ譛ｨ鄒ｩ逕ｷ', 1, 58);
INSERT 0 1
oddtbs=> insert into emp (name, gender, age) values('譁手陸豢句ｭ�', 2, 30);
INSERT 0 1
oddtbs=> select * from emp;
 code |   name   | gender | age |  hiredate
------+----------+--------+-----+------------
    1 | 驤ｴ譛ｨ鄒ｩ逕ｷ |      1 |  58 | 2009-08-12
    2 | 譁手陸豢句ｭ� |      2 |  30 | 2009-08-12
(2 rows)

窶ｻ code蛻励′閾ｪ蜍慕噪縺ｫ1縺九ｉ蜑ｲ繧頑険繧峨ｌ縺ｦ縺�ｋ縲�

繝�ヵ繧ｩ繝ｫ繝亥､縲√す繝ｼ繧ｱ繝ｳ繧ｹ縲ヾERIAL蝙�