PostgreSQL 8.0.4 ʸ��
��Υڡ��	��ᤷ		��	��Υڡ��

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

�ܼ�

42.1. ��

42.1.1. ��å��γ��
42.1.2. ��ĥ�䤤��碌�γ��
42.1.3. �񼰤Ƚ񼰥��

42.2. ��å��ή��

42.2.1. ��
42.2.2. �ʰ��䤤��碌
42.2.3. ��ĥ�䤤��碌
42.2.4. �ؿ��ƤӽФ�
42.2.5. COPY ��
42.2.6. ��Ʊ��
42.2.7. ��Υꥯ��Ȥμ��ä�
42.2.8. ��λ
42.2.9. SSL��å��Ź沽

42.3. ��å��Υǡ��

42.4. ��å��ν�

42.5. ��顼��ӷ��å��ե��

42.6. �ץ��ȥ��2.0��ѹ��

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

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

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

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

42.1. ��

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

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

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

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

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

42.1.1. ��å��γ��

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

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

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

42.1.2. ��ĥ�䤤��碌�γ��

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

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

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

42.1.3. �񼰤Ƚ񼰥��

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

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

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

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

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

42.1. ����

42.1.1. ��å����������γ���

42.1.2. ��ĥ�䤤��碌�γ���

42.1.3. �񼰤Ƚ񼰥�����

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

42.1. ��

42.1.1. ��å��γ��

42.1.2. ��ĥ�䤤��碌�γ��

42.1.3. �񼰤Ƚ񼰥��