drop table �v�Z�@�p��;
create table �v�Z�@�p�� (�p�� text, ����R�[�h varchar, ��l1A��� char(16));
create index �v�Z�@�p��index1 on �v�Z�@�p�� using btree (�p��);
create index �v�Z�@�p��index2 on �v�Z�@�p�� using hash (����R�[�h);
insert into �v�Z�@�p�� values('�R���s���[�^�f�B�X�v���C','�@A01��');
insert into �v�Z�@�p�� values('�R���s���[�^�O���t�B�b�N�X','��B10��');
insert into �v�Z�@�p�� values('�R���s���[�^�v���O���}�[','�lZ01��');
vacuum �v�Z�@�p��;
select * from �v�Z�@�p��;
            �p��            | ����R�[�h | ��l1a��� 
----------------------------+------------+------------
 �R���s���[�^�f�B�X�v���C   | �@A01��    | 
 �R���s���[�^�O���t�B�b�N�X | ��B10��    | 
 �R���s���[�^�v���O���}�[   | �lZ01��    | 
(3 rows)

select * from �v�Z�@�p�� where ����R�[�h = '�lZ01��';
           �p��           | ����R�[�h | ��l1a��� 
--------------------------+------------+------------
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
(1 row)

select * from �v�Z�@�p�� where ����R�[�h ~* '�lz01��';
           �p��           | ����R�[�h | ��l1a��� 
--------------------------+------------+------------
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
(1 row)

select * from �v�Z�@�p�� where ����R�[�h like '_Z01_';
           �p��           | ����R�[�h | ��l1a��� 
--------------------------+------------+------------
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
(1 row)

select * from �v�Z�@�p�� where ����R�[�h like '_Z%';
           �p��           | ����R�[�h | ��l1a��� 
--------------------------+------------+------------
 �R���s���[�^�v���O���}�[ | �lZ01��    | 
(1 row)

select * from �v�Z�@�p�� where �p�� ~ '�R���s���[�^[�f�O]';
            �p��            | ����R�[�h | ��l1a��� 
----------------------------+------------+------------
 �R���s���[�^�f�B�X�v���C   | �@A01��    | 
 �R���s���[�^�O���t�B�b�N�X | ��B10��    | 
(2 rows)

select * from �v�Z�@�p�� where �p�� ~* '�R���s���[�^[�f�O]';
            �p��            | ����R�[�h | ��l1a��� 
----------------------------+------------+------------
 �R���s���[�^�f�B�X�v���C   | �@A01��    | 
 �R���s���[�^�O���t�B�b�N�X | ��B10��    | 
(2 rows)

select *,character_length(�p��) from �v�Z�@�p��;
            �p��            | ����R�[�h | ��l1a��� | character_length 
----------------------------+------------+------------+------------------
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            |               12
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            |               13
 �R���s���[�^�v���O���}�[   | �lZ01��    |            |               12
(3 rows)

select *,octet_length(�p��) from �v�Z�@�p��;
            �p��            | ����R�[�h | ��l1a��� | octet_length 
----------------------------+------------+------------+--------------
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            |           24
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            |           26
 �R���s���[�^�v���O���}�[   | �lZ01��    |            |           24
(3 rows)

select *,position('�f' in �p��) from �v�Z�@�p��;
            �p��            | ����R�[�h | ��l1a��� | position 
----------------------------+------------+------------+----------
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            |        7
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            |        0
 �R���s���[�^�v���O���}�[   | �lZ01��    |            |        0
(3 rows)

select *,substring(�p�� from 10 for 4) from �v�Z�@�p��;
            �p��            | ����R�[�h | ��l1a��� | substring 
----------------------------+------------+------------+-----------
 �R���s���[�^�f�B�X�v���C   | �@A01��    |            | �v���C
 �R���s���[�^�O���t�B�b�N�X | ��B10��    |            | �B�b�N�X
 �R���s���[�^�v���O���}�[   | �lZ01��    |            | ���}�[
(3 rows)

copy �v�Z�@�p�� to stdout;
�R���s���[�^�f�B�X�v���C	�@A01��	\N
�R���s���[�^�O���t�B�b�N�X	��B10��	\N
�R���s���[�^�v���O���}�[	�lZ01��	\N