Re: COPY BINARY documentation - Mailing list pgsql-patches

Patch applied.  Thanks.

---------------------------------------------------------------------------


Lee Kindness wrote:
Content-Description: message body text

> The attached patch adds some clarification to the documentation of the
> binary format read/created by COPY BINARY. It also mentions the
> contrib/binarycopy module.
>
> Regards, Lee Kindness.
>

> Index: doc/src/sgml/ref/copy.sgml
> ===================================================================
> RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/ref/copy.sgml,v
> retrieving revision 1.46
> diff -c -r1.46 copy.sgml
> *** doc/src/sgml/ref/copy.sgml    9 May 2003 21:19:48 -0000    1.46
> --- doc/src/sgml/ref/copy.sgml    5 Aug 2003 13:09:19 -0000
> ***************
> *** 380,386 ****
>       The file format used for <command>COPY BINARY</command> changed in
>       <application>PostgreSQL</application> 7.4. The new format consists
>       of a file header, zero or more tuples containing the row data, and
> !     a file trailer.
>      </para>
>
>      <refsect3>
> --- 380,386 ----
>       The file format used for <command>COPY BINARY</command> changed in
>       <application>PostgreSQL</application> 7.4. The new format consists
>       of a file header, zero or more tuples containing the row data, and
> !     a file trailer. Headers and data are now in network byte order.
>      </para>
>
>      <refsect3>
> ***************
> *** 481,486 ****
> --- 481,495 ----
>   assumed to be in binary format (format code one).  It is anticipated that a
>   future extension may add a header field that allows per-column format codes
>   to be specified.
> +     </para>
> +
> +     <para>
> + To determine the appropriate binary format for the actual tuple data you
> + should consult the <application>PostgreSQL</application> source, in
> + particular the <function>*send</> and <function>*recv</> functions for
> + the data type (typically found in the <filename>src/backend/utils/adt</filename>
> + directory). The <application>contrib/binarycopy</application> module
> + can also be used to create an appropriate format file.
>       </para>
>
>       <para>

>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073