PostgreSQL 8.1.9ʸ��
��Υڡ��	��ᤷ		��	��Υڡ��

�� 43�ϥե��ȥ��/�Хå��ɥץ��ȥ��

�ܼ�

43.1. ��

43.1.1. ��å��γ��
43.1.2. ��ĥ�䤤��碌�γ��
43.1.3. �񼰤Ƚ񼰥��

43.2. ��å��ή��

43.2.1. ��
43.2.2. �ʰ��䤤��碌
43.2.3. ��ĥ�䤤��碌
43.2.4. �ؿ��ƤӽФ�
43.2.5. COPY��
43.2.6. ��Ʊ��
43.2.7. ��Υꥯ��Ȥμ��ä�
43.2.8. ��λ
43.2.9. SSL��å��Ź沽

43.3. ��å��Υǡ��

43.4. ��å��ν�

43.5. ��顼��ӷ��å��ե��

43.6. �ץ��ȥ��2.0��ѹ��

PostgreSQL�ϥե��ȥ��ɤȥХå��ɡʥ��饤��Ȥȥ��Сˤ��̿��˥�å��١��Υץ��ȥ��Ѥ��ޤ�� Υץ��ȥ��TCP/IP��Unix��åȤ򥵥ݡ��Ȥ��ޤ�� ݡ��ֹ�5432�ϡ��Υץ��ȥ��򥵥ݡ��Ȥ��륵��Ѥ�TCP�ݡ��ȤȤ��IANA��Ͽ��ޤ�� ºݤˤ�Ǥ�դ��ø��ݡ��ֹ��Ѥ��뤳�Ȥ��Ǥ��ޤ��

��ʸ��PostgreSQL 7.4�ʹߤ˼��줿�ץ��ȥ��3.0�С��ˤĤ��Ƶ��ܤ��ޤ�� Υץ��ȥ��С��ˤĤ��Ƥ��ϡ�PostgreSQL�ΰ��Υ�꡼��ʸ��򻲾Ȥ��Ƥ�� γ��׵��å��ϡ��Ф��Ф��饤��Ȥ��Ѥ��ͽ��Υץ��ȥ��С��Τ��ޤ�� θ塢��Фϲ�ǽ�Ǥ��Ф��Υץ��ȥ��˽��ޤ��

�ܥץ��ȥ��˹��ۤ��줿��٤ʵ�ǽ��㤨�С��³��Ω��ˤɤΤ褦��libpq��δĶ��ѿ��Ϥ��ˤˤĤ��Ƥϡ��ޤ��

��ΨŪ��ʣ��Υ��饤��Ȥ˥��ӥ��󶡤��뤿��ˡ��Фϳƥ��饤��Ѥ˿��"�Хå��"�ץ��ư��ޤ�� ߤμ��Ǥϡ��Ф��³��Ϥ��Ȥ��Τ��¨�¤˿��ҥץ��ޤ�� ϥץ��ȥ��Ф��Ʃ��Ǥ�� ץ��ȥ��Ȥ��̣�Ǥϡ�"�Хå��"��"��"�Ȥ��Ѹ��߸򴹲�ǽ�Ǥ��Ʊ�ͤ�"�ե��ȥ��"��"��饤��"��߸򴹲�ǽ�Ǥ��

43.1. ��

��Υץ��ȥ��Ǥϡ��³��Ϥ��̾��ʳ��ʬ��Ƥ��ޤ�� ³��ʳ��Ǥϡ��ե��ȥ��ɤϥ��Фؤ��³�򳫤��Ф��褦�˼��Ȥ��ޤ� �ʤ��ϻ��Ѥ��ǧ��ˡ�˱��ơ�ñ��Υ�å��ˤʤ뤫�⤷��ޤ��󤷡�ʣ��Υ�å��ˤʤ뤫�⤷��ޤ��ˡ� ��Ƥ��ޤ��С��Фϥե��ȥ��ɤ˾��־��ǽ�Ū��̾��ʳ��ޤ�� γ��׵��å��ץ��ȥ��Τ��ʬ�ϥ��Фˤ�äƶ�ư��ޤ��

�̾��δ֡��ե��ȥ��ɤ��䤤��碌�䤽��¾�Υ��ޥ�ɤ�Хå��ɤ��Хå��ɤ��䤤��碌�䤽��¾�α��ޤ�� Хå��ɤ��ꤵ�줺�˥�å��鷺��ʾ��NOTIFY�ʤɡˤ��ޤ��å��Τ��ʬ�ΤۤȤ�ɤϥե��ȥ��ɤ��׵�ˤ�äƶ�ư��ޤ��

��å��ν�λ��̾�ե��ȥ��ɤ��򤹤뤳�ȤǤ��ξ��ϥХå��ɤˤ�äƶ��ǽ��ޤ�� ɤ��ξ��Ǥ⡢�Хå��ɤ��³��Ĥ��λ��˼¹��Դ��ʡ˥ȥ�󥶥��ƥ��Хå��ޤ��

�̾��ϡ�SQL��ޥ�ɤ�2�ĤΥ��֥ץ��ȥ��Τɤ��餫��̤��Ƽ¹Ԥ��뤳�Ȥ��Ǥ��ޤ�� "�ʰ��䤤��碌"�ץ��ȥ��Ǥϡ��ե��ȥ��ɤϥƥ��Ȥ��䤤��碌ʸ��ñ��Хå��ɤˤ�äƲ��Ϥ��졢�¹Ԥ��ޤ�� "��ĥ�䤤��碌"�ץ��ȥ��Ǥϡ��䤤��碌�ν��ϡ��ϡ��ѥ�᡼��ͤη��դ��¹ԤȤ��ʣ��ʳ��ʬΥ��ޤ�� ϡ�;�פ�ʣ��Υ��ȤȤ��Ƚ��ǽ�ˤĤ��Ƥ��󶡤��ޤ��

�̾��ˤϡ��ˡ�COPY�Τ褦��ü��Υ��֥ץ��ȥ��뤬��ޤ��

43.1.1. ��å��γ��

��Ƥ��̿��ϥ�å��ȥ꡼��𤷤ޤ�� å��Ƭ�Х��Ȥϥ�å��̤��Ρ��4�Х��Ȥϥ�å��λĤ��Ĺ��ꤹ��ΤǤ� �ʤ��Ĺ��ˤϥ�å��Х��Ȥϴޤޤ�ޤ��󤬡��Ȥϴޤޤ�ޤ��ˡ� ��å��ƤλĤ��ʬ�ϡ��å��Ƿ�ޤ�ޤ�� Ū��ͳ�Τ��ᡢ��ֽ��˥��饤��Ȥ��å��ʳ��ϥ�å��ˤˤϥ�å��Х��ȤϤ��ޤ��

��å��ȥ꡼��Ʊ��ɤ��ˡ��Фȥ��饤��Ȥ�ξ��ϡ��̾��å��Ƥ��Ϥ��ˡ��ʥХ��ȿ��Ѥ��ơ˥�å��Τ�Хåե��ɤ߹��ߤޤ�� ˤ�ꡢ��Ƥ��˥��顼��Ф��줿��ˡ��ñ��줹�뤳�Ȥ��Ǥ��ޤ�� ʾ��ʥ�å��Хåե��뤿��˽�ʬ�ʥ��꤬�ʤ��ˤǤϡ��¦�ϡ��Х��ȿ��Ѥ��ơ��å��ɤ߼��Ƴ��ˤɤ��Ϥ��Ф��ɤ��ꤹ�뤳�Ȥ��Ǥ��ޤ��

ȿ�Фˡ��Фȥ��饤��Ȥ�ξ��ϡ��Դ��ʥ�å��褷��ʤ��褦��դ��ʤ��Фʤ�ޤ�� ̾��˥�å��Τ�Хåե��뤳�ȤǹԤ��ޤ�� å��Ʊ��Ǥ��˾�ߤϤۤȤ�ɤ��ޤ��Τǡ��å��̿��顼��ȯ��硢��Ū��ͣ��α��̿��Ǥ��뤳�ȤǤ��

43.1.2. ��ĥ�䤤��碌�γ��

��ĥ�䤤��碌�ץ��ȥ��Ǥϡ�SQL��ޥ�ɤμ¹Ԥ�ʣ��ʳ��ʬ�䤵��ޤ�� ʳ��֤��ݻ��֤ϡ���줿ʸ���ݡ����2��Υ��֥��Ȥ�ɽ��ޤ�� 줿ʸ�ϡ��ϡ��̣��ϡ��ƥ��䤤��碌ʸ��ηײ��̤�ɽ��ޤ�� 줿ʸ�ϼ¹Խ��ä��Ȥ�ɬ��⼨��ޤ�� �ѥ�᡼����ͤ���Ƥ��뤫�⤷��ʤ��Ǥ�� ݡ��ϡ��ƤΥѥ�᡼��ͤ��ꤵ�졢�¹Խ��ä��뤤�ϡ��˰��¹Ԥ��줿ʸ��ɽ��ޤ� ��SELECTʸ�Ǥϡ��ݡ��ϳ��Ƥ��륫��Ǥ��SELECT�ʳ��ʸ�򰷤��ޤ��Τǡ��Ǥϰۤʤ��Ѹ��Ѥ��褦��򤷤ޤ��ˡ�

�¹ԥ��Τϡ��ƥ��Ȥ��䤤��碌ʸ��󤫤��줿ʸ�����ʳ��줿ʸ��ɬ�פʥѥ�᡼��ͤˤ��ݡ���Х���ʳ��ݡ��䤤��碌��¹Ԥ���¹��ʳ��ʤ�ޤ�� Ԥ��֤��䤤��碌��SELECT��SHOW�ʤɡˤξ�硢��λ��뤿��ʣ��μ¹��ʳ��ɬ�פȤ��뤳�Ȥ��Ǥ��褦�ˡ��¹��ʳ��˸��ꤵ�줿�Կ��Τߤ��Ф��褦�ؼ��뤳�Ȥ��Ǥ��ޤ��

�Хå��ɤϽ��줿ʸ�ȥݡ��ʣ��뤳�Ȥ��Ǥ��ޤ� �ʤ��1�ĤΥ��å��ǤΤ�¸�߲�ǽ�Ǥ��ʣ��Υ��å��Ƕ�ͭ��뤳�ȤϤǤ��ޤ��ˡ� ¸�ߤ��줿ʸ�ȥݡ��ϡ��˳��Ƥ�줿̾��ǻ��Ȥ��ޤ�� ˡ�"̵̾��"��줿ʸ�ȥݡ��¸�ߤ��ޤ�� ̾��դ��Υ��֥��ȤȤۤȤ��Ʊ��ư��򤷤ޤ��䤤��碌�μ¹Ԥ��٤ΤߤǺ��˺�Ŭ��Ƥ��ޤ�� ̾��դ��֥��Ȥ��ʣ��λ��Ѥ��ꤷ�ƺ�Ŭ��Ƥ��ޤ��

43.1.3. �񼰤Ƚ񼰥��

��Υǡ��Υǡ��ʣ��ΰۤʤ��Τ��줫��ž��ǽ��ޤ�� PostgreSQL 7.4�ǥ��ݡ��Ȥ��񼰤�"�ƥ��"��"�Х��ʥ�"�ΤߤǤ��ץ��ȥ��Ͼ��γ�ĥ��ƽ��򤷤Ƥ��ޤ�� Ǥ�դ��ͤ�ɬ�פʽ񼰤��񼰥���ǻ��ꤵ��ޤ�� 饤��Ȥϡ�ž��ѥ�᡼��ͤ��줾��˽񼰥��ɤ��ꤹ�뤳�Ȥ⡢�䤤��碌��̤��󤽤줾��˽񼰥��ɤ��ꤹ�뤳�Ȥ��ǽ�Ǥ�� ƥ��ȤϽ񼰥��0��Х��ʥ�Ͻ񼰥��1�Ǥ�� ¾�ν񼰥��ɤϾ��Ѥ�ͽ�󤵤�Ƥ��ޤ��

�ͤΥƥ��ɽ��ϡ��Υǡ��Ѵ��ؿ��졢��դ��벿�餫��ʸ��Ǥ�� ž��ɽ��Ǥϡ�NULL��üʸ��Ϥ��ޤ�� ե��ȥ��ɤ�Cʸ��Ȥ��ƽ��ϡ�ɬ��ͤ�NULL��üʸ��ɲä��ʤ��Фʤ�ޤ�� ʤĤ��ǤǤ��ƥ��Ƚ񼰤Ǥ�NULL��ळ�ȤϤǤ��ޤ��ˡ�

��ѤΥХ��ʥ�ɽ��ϥͥåȥ��Х��Ƚ��Ƭ�˺Ǿ�̥Х��ȡˤ��Ѥ��ޤ�� ¾�Υǡ��ΥХ��ʥ�ɽ��ˤĤ��Ƥϡ�ʸ��⤷��ϥ��ɤ򻲾Ȥ��Ƥ�� ʣ��ʥǡ��ΥХ��ʥ�ɽ��ϥ��ФΥС��ˤ�äưۤʤ��ǽ��뤳�Ȥ��դ��Ƥ�� ̾�ƥ��Ƚ񼰤��ܿ��⤤��Ǥ��

��Υڡ��	�ۡ��	��Υڡ��
`pg_views`	��	��å��ή��

�� 43�ϥե���ȥ����/�Хå�����ɥץ��ȥ���

43.1. ����

43.1.1. ��å����������γ���

43.1.2. ��ĥ�䤤��碌�γ���

43.1.3. �񼰤Ƚ񼰥�����

�� 43�ϥե��ȥ��/�Хå��ɥץ��ȥ��

43.1. ��

43.1.1. ��å��γ��

43.1.2. ��ĥ�䤤��碌�γ��

43.1.3. �񼰤Ƚ񼰥��