Skip to content

Commit b1ee615

Browse files
committed
COPY BINARY uses the new binary I/O routines. Update a few more datatypes
so that COPY BINARY regression test passes.
1 parent 38d9919 commit b1ee615

File tree

12 files changed

+503
-258
lines changed

12 files changed

+503
-258
lines changed

doc/src/sgml/ref/copy.sgml

Lines changed: 12 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.45 2003/05/07 22:23:27 tgl Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.46 2003/05/09 21:19:48 tgl Exp $
33
PostgreSQL documentation
44
-->
55

@@ -541,28 +541,22 @@ ZW ZIMBABWE
541541
</para>
542542

543543
<para>
544-
XXX the following example is OBSOLETE and needs to be updated for the
545-
7.4 binary format:
546-
</para>
547-
548-
<para>
549-
The following is the same data, output in binary format on a
550-
Linux/i586 machine. The data is shown after filtering through the
544+
The following is the same data, output in binary format.
545+
The data is shown after filtering through the
551546
Unix utility <command>od -c</command>. The table has three columns;
552547
the first has type <type>char(2)</type>, the second has type <type>text</type>,
553548
and the third has type <type>integer</type>. All the rows have a null value
554549
in the third column.
555550
<programlisting>
556-
0000000 P G B C O P Y \n 377 \r \n \0 004 003 002 001
557-
0000020 \0 \0 \0 \0 \0 \0 \0 \0 003 \0 377 377 006 \0 \0 \0
558-
0000040 A F 377 377 017 \0 \0 \0 A F G H A N I S
559-
0000060 T A N \0 \0 003 \0 377 377 006 \0 \0 \0 A L 377
560-
0000100 377 \v \0 \0 \0 A L B A N I A \0 \0 003 \0
561-
0000120 377 377 006 \0 \0 \0 D Z 377 377 \v \0 \0 \0 A L
562-
0000140 G E R I A \0 \0 003 \0 377 377 006 \0 \0 \0 Z
563-
0000160 M 377 377 \n \0 \0 \0 Z A M B I A \0 \0 003
564-
0000200 \0 377 377 006 \0 \0 \0 Z W 377 377 \f \0 \0 \0 Z
565-
0000220 I M B A B W E \0 \0 377 377
551+
0000000 P G C O P Y \n 377 \r \n \0 \0 \0 \0 \0 \0
552+
0000020 \0 \0 \0 \0 003 \0 \0 \0 002 A F \0 \0 \0 013 A
553+
0000040 F G H A N I S T A N 377 377 377 377 \0 003
554+
0000060 \0 \0 \0 002 A L \0 \0 \0 007 A L B A N I
555+
0000100 A 377 377 377 377 \0 003 \0 \0 \0 002 D Z \0 \0 \0
556+
0000120 007 A L G E R I A 377 377 377 377 \0 003 \0 \0
557+
0000140 \0 002 Z M \0 \0 \0 006 Z A M B I A 377 377
558+
0000160 377 377 \0 003 \0 \0 \0 002 Z W \0 \0 \0 \b Z I
559+
0000200 M B A B W E 377 377 377 377 377 377
566560
</programlisting>
567561
</para>
568562
</refsect1>

0 commit comments

Comments
 (0)