PostgreSQL �� SEQUENCE �̎���

PostgreSQL �� SEQUENCE �̎��̂̓e�[�u���ł��B CREATE SEQUENCE �����Ƃ��� SEQUENCE �Ɠ������O�� 1 �s�����̓���ȃe�[�u�����쐬���܂��B

���̂悤�� \d �� SEQUENCE �̏�Ԃ��m�F���邱�Ƃ��ł��܂��B

db=# \d test_sequence

      Sequence "public.test_sequence"
    Column     |  Type   |        Value
---------------+---------+---------------------
sequence_name | name    | test_sequence
last_value    | bigint  | 9
start_value   | bigint  | 1
increment_by  | bigint  | 1
max_value     | bigint  | 9223372036854775807
min_value     | bigint  | 1
cache_value   | bigint  | 1
log_cnt       | bigint  | 26
is_cycled     | boolean | f
is_called     | boolean | t

SEQUENCE �̎��̂̓e�[�u���Ȃ̂� ���̂悤�� SQL �� FROM ��� SEQUENCE �����w�肵�Ă� ���g�����邱�Ƃ��ł��܂��B

db=# \x
Expanded display is on.

db=# SELECT * FROM public.test_sequence;

-[ RECORD 1 ]-+--------------------
sequence_name | test_sequence
last_value    | 9
start_value   | 1
increment_by  | 1
max_value     | 9223372036854775807
min_value     | 1
cache_value   | 1
log_cnt       | 26
is_cycled     | f
is_called     | t 

PostgreSQL �� view ���e�[�u���ƃ��[�����g���Ď������Ă��܂��� ���Ȃ������ő����̋@�\����������Ƃ����̂̓J�b�R�����ł��ˁB

Google �T�C�g������

Amazon�A�\�V�G�C�g