COPY ���ޥ�ɤ˴�Ϣ�����ؿ�

85) The copy command in Postgres has options to read from or write to the network connection used by libpq++. Therefore, functions are necessary to access this network connection directly so applications may take full advantage of this capability.

Postgres �� COPY ���ޥ�ɤϡ� libpq++ ���ȤäƤ���ͥåȥ����³���Ф����ɤ߹��ߡ� ���뤤�Ͻ񤭹��ߤ����֤��Ȥ��Ǥ���褦�ˤʤäƤ��ޤ��� �����Ǥ��Υͥåȥ����³��ľ�ܥ����������뤿��δؿ���ɬ�פˤʤ�ޤ��� ������󥢥ץꥱ�������⤳�ε�ǽ�ˤ�äƽ�ʬ�ʲ��ä������Ǥ��礦��

• 86) PgDatabase::GetLine reads a newline-terminated line of characters (transmitted by the backend server) into a buffer string of size length.

  PgDatabase::GetLine �ϲ��Ԥǽ�ü����ʸ����ʥХå�����ɤ����������줿��Ρˤ�Ĺ�� length �ΥХåե� string ���ɤ߹��ߤޤ���

          int PgDatabase::GetLine(char* string, int length)
         

  87) Like the Unix system routine fgets (3), this routine copies up to length-1 characters into string. It is like gets (3), however, in that it converts the terminating newline into a null character.

  Unix �����ƥ�롼���� fgets(3) ��Ʊ�͡� ���Υ롼����� string �˺��� (length-1) �Ĥ�ʸ���򥳥ԡ����ޤ�����������ü�β��Ԥ� NULL ʸ�����֤������������Ǥ� gets(3) �˻��Ƥ��ޤ���

  88) PgDatabase::GetLine returns EOF at end of file, 0 if the entire line has been read, and 1 if the buffer is full but the terminating newline has not yet been read.

  PgDatabase::GetLine �ϥե����뽪ü�� EOF �� �����Τ��ɤ߹��ޤ��� 0 ���֤��ޤ��� �����ơ��ޤ���ü�β��Ԥ��ɤ߹��ޤ�Ƥ��ʤ������˥Хåե������äѤ��� �ʤäƤ��ޤä����� 1 ���֤��ޤ���

  89) Notice that the application must check to see if a new line consists of a single period ("."), which indicates that the backend server has finished sending the results of the copy. Therefore, if the application ever expects to receive lines that are more than length-1 characters long, the application must be sure to check the return value of PgDatabase::GetLine very carefully.

  ���ץꥱ�������Ͽ������ɤ߹�����Ԥ��� �ԥꥪ�ɰ�ʸ�� (".") �Ǥ��뤫�ɤ�����ǧ���ʤ���Фʤ�ޤ��� [1] ����ʸ���� COPY ���ޥ�ɤη�̤�Хå�����ɥ����Ф����������������Ȥ򼨤���ΤǤ��� �������ä� (length-1) ʸ����Ķ����Ԥμ��������ꤵ���ΤǤ���С� ���ץꥱ�������� PgDatabase::GetLine ���֤��ͤ�褯���դ��ơ��μ¤˥����å����ʤ���Фʤ�ޤ���

• PgDatabase::PutLine 90) Sends a null-terminated string to the backend server. NULL ��ü��ʸ���� string ��Хå�����ɥ����Ф��������ޤ���

          void PgDatabase::PutLine(char* string)
         

  91) The application must explicitly send a single period character (".") to indicate to the backend that it has finished sending its data.

  ���ץꥱ�������ϥǡ��������δ�λ��Хå�����ɤ˼�������ˡ� �ԥꥪ�ɰ�ʸ�� (".") ������Ū���������ʤ���Фʤ�ޤ��� [1]

• PgDatabase::EndCopy 92) syncs with the backend. �Хå�����ɤ�Ʊ�����ޤ���

          int PgDatabase::EndCopy()
         

  93) This function waits until the backend has finished processing the copy. It should either be issued when the last string has been sent to the backend using PgDatabase::PutLine or when the last string has been received from the backend using PgDatabase::GetLine. It must be issued or the backend may get "out of sync" with the frontend. Upon return from this function, the backend is ready to receive the next query. ���δؿ��ϥХå�����ɤ� COPY ������λ����Τ��Ԥ��ޤ��� ���δؿ��� PgDatabase::PutLine ��Ȥä��Хå�����ɤؤ�ʸ������������λ���������� ���뤤�� PgDatabase::GetLine ��Ȥä��Хå�����ɤ����ʸ�����������λ���������Ρ� ������Ǥ�ƤӽФ��ʤ���Фʤ�ޤ��� ����ʤ��ȡ��Хå�����ɤ��ե���ȥ���ɤȤΡ�Ʊ������� �򵯤����Ƥ��ޤ����⤷��ޤ��� ���δؿ�������ä������ǡ��Хå�����ɤμ����䤤��碌�����������������ޤ���

  94) The return value is 0 on successful completion, nonzero otherwise.

  Ʊ������������� 0 �򡤤����Ǥʤ���� 0 �ʳ����ͤ��֤��ޤ���

95) As an example:

����Ǥ���

96)
        PgDatabase data;
        data.Exec("create table foo (a int4, b char16, d float8)");
        data.Exec("copy foo from stdin");
        data.putline("3\etHello World\et4.5\en");
        data.putline("4\etGoodbye World\et7.11\en");
        &...
        data.putline(".\en");
        data.endcopy();
������ ...'\et','\en' �Ȥϡ���

        PgDatabase.data;
        data.Exec("create table foo (a int4, b char(16), d float8)");
        data.Exec("copy foo from stdin");
        data.PutLine("3\tHello World\t4.5\n");
        data.PutLine("4\tGoodbye World\t7.11\n");
        &...
        data.PutLine(".\n");
        data.EndCopy();